PREVIEW / etf_1hour / 2009-02-23

all etf 1-hour files

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

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-23 04:00:00	SPY	ETF	78.66	78.85	78.55	78.85	21273.0
2009-02-23 05:00:00	SPY	ETF	78.9	78.94	78.41	78.41	31250.0
2009-02-23 06:00:00	SPY	ETF	78.49	78.51	78.22	78.43	81781.0
2009-02-23 07:00:00	SPY	ETF	78.37	78.37	77.68	78.04	1560530.0
2009-02-23 08:00:00	SPY	ETF	77.86	78.72	77.84	78.51	4341943.0
2009-02-23 09:00:00	SPY	ETF	78.51	78.51	77.42	77.55	36354005.0
2009-02-23 10:00:00	SPY	ETF	77.55	77.63	76.33	76.35	55195335.0
2009-02-23 11:00:00	SPY	ETF	76.36	76.71	76.05	76.21	34649071.0
2009-02-23 12:00:00	SPY	ETF	76.21	76.24	75.33	75.36	35636655.0
2009-02-23 13:00:00	SPY	ETF	75.36	77.725	75.31	75.601	43494291.0
2009-02-23 14:00:00	SPY	ETF	75.59	76.22	75.02	75.03	56179569.0
2009-02-23 15:00:00	SPY	ETF	75.04	75.49	74.59	74.78	87969578.0
2009-02-23 16:00:00	SPY	ETF	74.73	75.56	74.47	74.94	15756243.0
2009-02-23 17:00:00	SPY	ETF	74.93	78.2	74.9	75.12	1781622.0
2009-02-23 18:00:00	SPY	ETF	75.11	75.19	75.01	75.01	405075.0
2009-02-23 19:00:00	SPY	ETF	75.01	75.32	74.98	75.19	153420.0
2009-02-23 04:00:00	QQQ	ETF	29.3	29.4	29.3	29.4	3440.0
2009-02-23 05:00:00	QQQ	ETF	29.41	29.43	29.33	29.33	1212.0
2009-02-23 06:00:00	QQQ	ETF	29.18	29.2	29.15	29.15	1600.0
2009-02-23 07:00:00	QQQ	ETF	29.23	29.23	28.98	29.11	229861.0
2009-02-23 08:00:00	QQQ	ETF	29.05	29.25	29.05	29.18	1479800.0
2009-02-23 09:00:00	QQQ	ETF	29.17	29.17	28.61	28.64	16595410.0
2009-02-23 10:00:00	QQQ	ETF	28.6405	28.68	28.35	28.36	23278595.0
2009-02-23 11:00:00	QQQ	ETF	28.36	28.49	28.17	28.22	16517950.0
2009-02-23 12:00:00	QQQ	ETF	28.22	28.28	28.02	28.022	15030523.0
2009-02-23 13:00:00	QQQ	ETF	28.02	28.24	28.01	28.11	18367778.0
2009-02-23 14:00:00	QQQ	ETF	28.11	28.31	27.91	27.93	24352705.0
2009-02-23 15:00:00	QQQ	ETF	27.92	28.09	27.73	27.88	38021618.0
2009-02-23 16:00:00	QQQ	ETF	27.88	28.01	27.79	27.95	10211252.0
2009-02-23 17:00:00	QQQ	ETF	28.8797	28.8797	27.96	28.0	3727267.0
2009-02-23 18:00:00	QQQ	ETF	27.98	28.01	27.96	27.96	40775.0
2009-02-23 19:00:00	QQQ	ETF	27.96	28.02	27.96	28.02	89085.0
2009-02-23 06:00:00	IWM	ETF	41.59	41.59	41.59	41.59	2500.0
2009-02-23 07:00:00	IWM	ETF	41.49	41.5	41.21	41.33	28400.0
2009-02-23 08:00:00	IWM	ETF	41.32	41.75	41.29	41.58	388356.0
2009-02-23 09:00:00	IWM	ETF	41.57	41.58	40.86	40.95	5305669.0
2009-02-23 10:00:00	IWM	ETF	40.94	41.03	40.12	40.13	13248508.0
2009-02-23 11:00:00	IWM	ETF	40.13	40.38	40.07	40.19	7487831.0
2009-02-23 12:00:00	IWM	ETF	40.19	40.25	39.83	39.84	6560180.0
2009-02-23 13:00:00	IWM	ETF	39.83	40.13	39.78	39.97	8284569.0
2009-02-23 14:00:00	IWM	ETF	39.97	40.43	39.68	39.71	13457948.0
2009-02-23 15:00:00	IWM	ETF	39.7	40.01	39.47	39.55	18175374.0
2009-02-23 16:00:00	IWM	ETF	39.55	41.0907	39.48	41.0907	3427658.0
2009-02-23 17:00:00	IWM	ETF	41.0908	41.0908	39.85	39.89	1515464.0
2009-02-23 18:00:00	IWM	ETF	39.86	39.86	39.79	39.79	1600.0
2009-02-23 19:00:00	IWM	ETF	39.86	39.86	39.85	39.86	1000.0
2009-02-23 04:00:00	DIA	ETF	74.55	74.55	74.15	74.15	600.0
2009-02-23 05:00:00	DIA	ETF	74.5	74.59	74.5	74.58	500.0
2009-02-23 06:00:00	DIA	ETF	74.49	74.52	74.49	74.52	200.0
2009-02-23 07:00:00	DIA	ETF	74.42	74.42	73.95	74.21	15926.0

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

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