PREVIEW / etf_1hour / 2008-09-23

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-09-23.parquet
  size:    115 KB
  rows:    3,670

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
2008-09-23 04:00:00	SPY	ETF	121.49	121.49	121.01	121.01	1300.0
2008-09-23 05:00:00	SPY	ETF	121.01	121.01	120.87	120.87	1800.0
2008-09-23 06:00:00	SPY	ETF	121.07	121.21	120.76	120.82	246814.0
2008-09-23 07:00:00	SPY	ETF	120.86	121.26	120.62	120.75	943299.0
2008-09-23 08:00:00	SPY	ETF	120.76	121.36	120.48	120.89	2450126.0
2008-09-23 09:00:00	SPY	ETF	120.9	122.02	120.52	121.31	28951332.0
2008-09-23 10:00:00	SPY	ETF	121.32	122.0	120.56	120.82	38089346.0
2008-09-23 11:00:00	SPY	ETF	120.82	121.39	120.43	120.72	30507885.0
2008-09-23 12:00:00	SPY	ETF	120.73	121.06	119.85	119.88	26680313.0
2008-09-23 13:00:00	SPY	ETF	119.89	119.93	118.5	119.02	53628075.0
2008-09-23 14:00:00	SPY	ETF	119.025	120.75	118.28	120.23	62690316.0
2008-09-23 15:00:00	SPY	ETF	120.23	121.19	118.55	118.72	57834781.0
2008-09-23 16:00:00	SPY	ETF	118.7	121.31	118.39	118.8	19872143.0
2008-09-23 17:00:00	SPY	ETF	118.82	120.5	118.55	120.44	809437.0
2008-09-23 18:00:00	SPY	ETF	120.42	120.8	120.07	120.14	1124692.0
2008-09-23 19:00:00	SPY	ETF	120.13	120.35	119.5	120.01	248165.0
2008-09-23 04:00:00	QQQ	ETF	41.09	41.1	41.09	41.1	1800.0
2008-09-23 05:00:00	QQQ	ETF	40.97	40.97	40.97	40.97	100.0
2008-09-23 06:00:00	QQQ	ETF	40.96	40.96	40.89	40.93	400.0
2008-09-23 07:00:00	QQQ	ETF	40.94	41.09	40.88	40.95	166942.0
2008-09-23 08:00:00	QQQ	ETF	40.95	41.24	40.86	41.24	1232577.0
2008-09-23 09:00:00	QQQ	ETF	41.23	41.52	41.11	41.38	23764290.0
2008-09-23 10:00:00	QQQ	ETF	41.38	41.75	41.26	41.3717	26310744.0
2008-09-23 11:00:00	QQQ	ETF	41.37	41.62	41.25	41.3401	11750300.0
2008-09-23 12:00:00	QQQ	ETF	41.34	41.39	40.93	40.9883	9772465.0
2008-09-23 13:00:00	QQQ	ETF	40.9889	40.99	40.44	40.66	18880606.0
2008-09-23 14:00:00	QQQ	ETF	40.6695	41.41	40.56	41.26	21648646.0
2008-09-23 15:00:00	QQQ	ETF	41.26	41.52	40.49	40.58	28072359.0
2008-09-23 16:00:00	QQQ	ETF	40.58	40.9698	40.47	40.49	3050356.0
2008-09-23 17:00:00	QQQ	ETF	40.51	41.0	40.48	41.0	365225.0
2008-09-23 18:00:00	QQQ	ETF	40.91	41.2	40.83	40.85	1653630.0
2008-09-23 19:00:00	QQQ	ETF	40.87	40.92	40.84	40.9	183261.0
2008-09-23 07:00:00	IWM	ETF	71.97	72.03	71.82	71.9	50400.0
2008-09-23 08:00:00	IWM	ETF	71.89	72.11	71.69	72.09	249430.0
2008-09-23 09:00:00	IWM	ETF	72.1	72.52	71.77	72.15	6720799.0
2008-09-23 10:00:00	IWM	ETF	72.16	72.62	71.87	72.03	9844647.0
2008-09-23 11:00:00	IWM	ETF	72.03	72.35	71.72	71.74	9236373.0
2008-09-23 12:00:00	IWM	ETF	71.74	71.98	71.42	71.6	7279085.0
2008-09-23 13:00:00	IWM	ETF	71.6	71.62	70.83	71.12	10375652.0
2008-09-23 14:00:00	IWM	ETF	71.11	72.34	70.9	71.83	15686530.0
2008-09-23 15:00:00	IWM	ETF	71.84	72.14	70.81	70.98	19304683.0
2008-09-23 16:00:00	IWM	ETF	70.98	72.0	70.66	70.99	5712328.0
2008-09-23 17:00:00	IWM	ETF	70.8	72.0	70.6	71.8	2104638.0
2008-09-23 18:00:00	IWM	ETF	71.95	71.99	71.72	71.8	11085.0
2008-09-23 19:00:00	IWM	ETF	71.8	71.8	71.55	71.55	2500.0
2008-09-23 07:00:00	DIA	ETF	110.0	110.37	110.0	110.03	5400.0
2008-09-23 08:00:00	DIA	ETF	110.2	110.52	109.9	110.36	67324.0
2008-09-23 09:00:00	DIA	ETF	110.32	111.27	110.05	110.66	3007546.0
2008-09-23 10:00:00	DIA	ETF	110.68	111.38	110.12	110.37	4477887.0
2008-09-23 11:00:00	DIA	ETF	110.35	111.06	110.1	110.5	3341306.0

> showing 50 of 3,670 rows — these rows as CSV

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