PREVIEW / etf_1hour / 2010-04-09

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-04-09.parquet
  size:    156 KB
  rows:    4,835

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2010-04-09 04:00:00	SPY	ETF	119.14	119.15	119.11	119.15	1300.0
2010-04-09 05:00:00	SPY	ETF	119.1	119.12	119.0	119.08	1400.0
2010-04-09 06:00:00	SPY	ETF	119.04	119.15	119.04	119.15	18950.0
2010-04-09 07:00:00	SPY	ETF	119.13	119.18	119.09	119.09	465785.0
2010-04-09 08:00:00	SPY	ETF	119.09	119.15	119.07	119.07	635346.0
2010-04-09 09:00:00	SPY	ETF	119.06	119.16	118.81	119.1383	25708693.0
2010-04-09 10:00:00	SPY	ETF	119.13	119.3	118.8	118.99	29524378.0
2010-04-09 11:00:00	SPY	ETF	118.99	119.36	118.97	119.26	15690182.0
2010-04-09 12:00:00	SPY	ETF	119.2583	119.34	119.14	119.18	6855416.0
2010-04-09 13:00:00	SPY	ETF	119.18	119.25	119.0	119.055	10883118.0
2010-04-09 14:00:00	SPY	ETF	119.05	119.28	118.97	119.22	10152909.0
2010-04-09 15:00:00	SPY	ETF	119.22	119.6	119.13	119.54	20506862.0
2010-04-09 16:00:00	SPY	ETF	119.54	119.77	118.7514	119.68	9527854.0
2010-04-09 17:00:00	SPY	ETF	119.68	119.74	119.63	119.74	211643.0
2010-04-09 18:00:00	SPY	ETF	119.74	119.82	119.72	119.82	89987.0
2010-04-09 19:00:00	SPY	ETF	119.84	119.92	119.75	119.87	214801.0
2010-04-09 06:00:00	QQQ	ETF	48.85	48.85	48.85	48.85	500.0
2010-04-09 07:00:00	QQQ	ETF	48.85	48.88	48.84	48.86	76300.0
2010-04-09 08:00:00	QQQ	ETF	48.84	48.85	48.83	48.83	55675.0
2010-04-09 09:00:00	QQQ	ETF	48.83	48.83	48.635	48.7799	8415055.0
2010-04-09 10:00:00	QQQ	ETF	48.78	48.85	48.68	48.775	13070989.0
2010-04-09 11:00:00	QQQ	ETF	48.77	48.9	48.77	48.86	6166835.0
2010-04-09 12:00:00	QQQ	ETF	48.86	48.9	48.8057	48.8638	3206020.0
2010-04-09 13:00:00	QQQ	ETF	48.86	48.91	48.8	48.83	4463424.0
2010-04-09 14:00:00	QQQ	ETF	48.83	48.93	48.79	48.91	4700413.0
2010-04-09 15:00:00	QQQ	ETF	48.91	49.05	48.87	49.02	9149235.0
2010-04-09 16:00:00	QQQ	ETF	49.02	49.14	48.7938	49.08	3400050.0
2010-04-09 17:00:00	QQQ	ETF	49.08	49.11	48.98	49.02	134635.0
2010-04-09 18:00:00	QQQ	ETF	49.01	49.06	49.01	49.06	41935.0
2010-04-09 19:00:00	QQQ	ETF	49.07	49.07	49.02	49.05	11151.0
2010-04-09 07:00:00	IWM	ETF	69.97	69.98	69.93	69.93	24600.0
2010-04-09 08:00:00	IWM	ETF	69.93	70.0	69.89	69.98	315587.0
2010-04-09 09:00:00	IWM	ETF	69.97	70.01	69.5	69.86	10250479.0
2010-04-09 10:00:00	IWM	ETF	69.87	70.11	69.79	69.93	9336309.0
2010-04-09 11:00:00	IWM	ETF	69.93	70.16	69.92	70.095	2891061.0
2010-04-09 12:00:00	IWM	ETF	70.1	70.19	70.06	70.08	3026775.0
2010-04-09 13:00:00	IWM	ETF	70.08	70.15	69.95	69.99	3823675.0
2010-04-09 14:00:00	IWM	ETF	69.99	70.18	69.92	70.14	3843872.0
2010-04-09 15:00:00	IWM	ETF	70.14	70.26	70.03	70.23	12157925.0
2010-04-09 16:00:00	IWM	ETF	70.23	70.4	69.9562	70.36	5352228.0
2010-04-09 17:00:00	IWM	ETF	70.36	70.41	70.1776	70.35	8942.0
2010-04-09 18:00:00	IWM	ETF	70.38	70.39	70.32	70.36	5150.0
2010-04-09 19:00:00	IWM	ETF	70.33	70.34	70.33	70.33	2600.0
2010-04-09 07:00:00	DIA	ETF	109.67	109.69	109.66	109.67	1200.0
2010-04-09 08:00:00	DIA	ETF	109.67	109.67	109.61	109.64	28550.0
2010-04-09 09:00:00	DIA	ETF	109.63	109.69	109.41	109.6658	1219905.0
2010-04-09 10:00:00	DIA	ETF	109.67	109.84	109.41	109.61	1622216.0
2010-04-09 11:00:00	DIA	ETF	109.61	109.94	109.6	109.81	665733.0
2010-04-09 12:00:00	DIA	ETF	109.81	109.89	109.72	109.75	449792.0
2010-04-09 13:00:00	DIA	ETF	109.76	109.77	109.59	109.62	398618.0

> showing 50 of 4,835 rows — these rows as CSV

> unlock the full archive -- $79 one-time