PREVIEW / etf_1hour / 2009-02-20

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-02-20.parquet
  size:    133 KB
  rows:    4,111

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
2009-02-20 04:00:00	SPY	ETF	77.4	77.46	76.96	77.06	9319.0
2009-02-20 05:00:00	SPY	ETF	77.11	77.34	77.01	77.09	5000.0
2009-02-20 06:00:00	SPY	ETF	77.2	77.38	77.2	77.25	7046.0
2009-02-20 07:00:00	SPY	ETF	77.24	77.31	76.82	77.06	1222687.0
2009-02-20 08:00:00	SPY	ETF	77.08	77.38	76.85	76.99	4598176.0
2009-02-20 09:00:00	SPY	ETF	76.98	77.53	76.62	77.4	48713017.0
2009-02-20 10:00:00	SPY	ETF	77.4	77.89	77.0	77.11	70996205.0
2009-02-20 11:00:00	SPY	ETF	77.11	77.35	76.49	76.76	43293582.0
2009-02-20 12:00:00	SPY	ETF	76.76	77.28	76.15	76.33	39306685.0
2009-02-20 13:00:00	SPY	ETF	76.33	76.63	75.77	76.48	49644706.0
2009-02-20 14:00:00	SPY	ETF	76.49	78.34	76.0	77.73	103119495.0
2009-02-20 15:00:00	SPY	ETF	77.73	78.2565	76.81	77.41	91196258.0
2009-02-20 16:00:00	SPY	ETF	77.43	77.6111	76.3201	77.41	17134058.0
2009-02-20 17:00:00	SPY	ETF	77.44	77.57	77.36	77.52	949822.0
2009-02-20 18:00:00	SPY	ETF	77.52	77.96	77.52	77.75	121537.0
2009-02-20 19:00:00	SPY	ETF	77.7	77.71	77.55	77.65	13663.0
2009-02-20 04:00:00	QQQ	ETF	28.5	28.5	28.38	28.38	1286.0
2009-02-20 05:00:00	QQQ	ETF	28.35	28.42	28.35	28.42	1175.0
2009-02-20 06:00:00	QQQ	ETF	28.45	28.47	28.44	28.46	1400.0
2009-02-20 07:00:00	QQQ	ETF	28.42	28.49	28.37	28.45	94113.0
2009-02-20 08:00:00	QQQ	ETF	28.44	28.55	28.39	28.43	1068015.0
2009-02-20 09:00:00	QQQ	ETF	28.42	28.75	28.34	28.67	23540139.0
2009-02-20 10:00:00	QQQ	ETF	28.68	28.88	28.6	28.67	25700050.0
2009-02-20 11:00:00	QQQ	ETF	28.67	28.74	28.57	28.68	24478150.0
2009-02-20 12:00:00	QQQ	ETF	28.6825	28.84	28.51	28.565	19292702.0
2009-02-20 13:00:00	QQQ	ETF	28.56	28.61	28.39	28.53	20708747.0
2009-02-20 14:00:00	QQQ	ETF	28.53	29.15	28.47	28.95	49738269.0
2009-02-20 15:00:00	QQQ	ETF	28.95	28.99	28.69	28.88	40376686.0
2009-02-20 16:00:00	QQQ	ETF	28.88	28.92	28.81	28.85	4710615.0
2009-02-20 17:00:00	QQQ	ETF	28.85	28.97	28.85	28.97	104414.0
2009-02-20 18:00:00	QQQ	ETF	28.98	29.0	28.92	29.0	73745.0
2009-02-20 19:00:00	QQQ	ETF	28.98	29.05	28.96	29.03	17569.0
2009-02-20 06:00:00	IWM	ETF	41.17	41.17	41.12	41.12	800.0
2009-02-20 07:00:00	IWM	ETF	41.04	41.04	40.86	40.98	17545.0
2009-02-20 08:00:00	IWM	ETF	40.94	41.31	40.75	40.93	178925.0
2009-02-20 09:00:00	IWM	ETF	40.93	41.38	40.59	41.29	11879491.0
2009-02-20 10:00:00	IWM	ETF	41.3	41.6	41.08	41.15	9485096.0
2009-02-20 11:00:00	IWM	ETF	41.15	41.23	40.67	40.7622	6122773.0
2009-02-20 12:00:00	IWM	ETF	40.77	40.96	40.39	40.491	9571808.0
2009-02-20 13:00:00	IWM	ETF	40.49	40.66	40.19	40.57	7733159.0
2009-02-20 14:00:00	IWM	ETF	40.57	41.64	40.4	41.24	16815109.0
2009-02-20 15:00:00	IWM	ETF	41.23	41.31	40.4	41.16	17090323.0
2009-02-20 16:00:00	IWM	ETF	41.15	41.18	40.7165	41.0	2339638.0
2009-02-20 17:00:00	IWM	ETF	40.98	41.05	40.93	41.05	32368.0
2009-02-20 18:00:00	IWM	ETF	41.12	41.15	41.12	41.15	1000.0
2009-02-20 04:00:00	DIA	ETF	73.99	74.2	73.62	73.62	2590.0
2009-02-20 05:00:00	DIA	ETF	73.65	73.65	73.65	73.65	200.0
2009-02-20 06:00:00	DIA	ETF	73.73	73.8	73.72	73.76	1322.0
2009-02-20 07:00:00	DIA	ETF	73.64	73.74	73.34	73.46	48976.0
2009-02-20 08:00:00	DIA	ETF	73.55	73.76	73.43	73.52	157318.0

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

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