PREVIEW / etf_1hour / 2008-07-24

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-07-24.parquet
  size:    112 KB
  rows:    3,577

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-07-24 05:00:00	SPY	ETF	128.09	128.09	127.82	127.84	1400.0
2008-07-24 06:00:00	SPY	ETF	127.8	127.98	127.8	127.88	187800.0
2008-07-24 07:00:00	SPY	ETF	127.87	128.08	127.62	127.98	1011702.0
2008-07-24 08:00:00	SPY	ETF	127.98	128.12	127.74	128.04	3015023.0
2008-07-24 09:00:00	SPY	ETF	128.05	128.41	127.57	127.7201	25700853.0
2008-07-24 10:00:00	SPY	ETF	127.72	127.72	127.1	127.198	48093746.0
2008-07-24 11:00:00	SPY	ETF	127.19	127.32	126.55	126.89	37647578.0
2008-07-24 12:00:00	SPY	ETF	126.89	126.99	126.43	126.71	18191490.0
2008-07-24 13:00:00	SPY	ETF	126.71	126.8	126.41	126.54	19085358.0
2008-07-24 14:00:00	SPY	ETF	126.54	126.6	125.83	126.1099	34720375.0
2008-07-24 15:00:00	SPY	ETF	126.1	126.38	125.16	125.43	51296107.0
2008-07-24 16:00:00	SPY	ETF	125.39	126.116	125.18	125.36	6184462.0
2008-07-24 17:00:00	SPY	ETF	125.42	125.56	125.42	125.55	89262.0
2008-07-24 18:00:00	SPY	ETF	125.55	125.57	125.52	125.53	20127.0
2008-07-24 19:00:00	SPY	ETF	125.52	125.56	125.44	125.52	35324.0
2008-07-24 04:00:00	QQQ	ETF	45.54	45.54	45.49	45.5	3900.0
2008-07-24 06:00:00	QQQ	ETF	45.48	45.51	45.42	45.42	21700.0
2008-07-24 07:00:00	QQQ	ETF	45.44	45.57	45.38	45.52	380202.0
2008-07-24 08:00:00	QQQ	ETF	45.52	45.59	45.43	45.59	1216457.0
2008-07-24 09:00:00	QQQ	ETF	45.59	45.67	45.26	45.4	21722918.0
2008-07-24 10:00:00	QQQ	ETF	45.39	45.39	45.03	45.17	23444515.0
2008-07-24 11:00:00	QQQ	ETF	45.17	45.22	44.91	45.14	17225246.0
2008-07-24 12:00:00	QQQ	ETF	45.1399	45.26	44.98	45.07	8389639.0
2008-07-24 13:00:00	QQQ	ETF	45.07	45.26	44.92	45.2	17869759.0
2008-07-24 14:00:00	QQQ	ETF	45.2	45.23	44.92	45.1	15347214.0
2008-07-24 15:00:00	QQQ	ETF	45.09	45.22	44.65	44.68	25452483.0
2008-07-24 16:00:00	QQQ	ETF	44.68	45.11	44.48	44.63	4011988.0
2008-07-24 17:00:00	QQQ	ETF	44.63	44.78	44.62	44.75	504093.0
2008-07-24 18:00:00	QQQ	ETF	44.74	44.77	44.73	44.73	92034.0
2008-07-24 19:00:00	QQQ	ETF	44.75	44.75	44.7	44.72	27542.0
2008-07-24 05:00:00	IWM	ETF	71.85	71.85	71.7	71.7	200.0
2008-07-24 06:00:00	IWM	ETF	71.75	71.77	71.75	71.76	700.0
2008-07-24 07:00:00	IWM	ETF	71.57	71.8	71.51	71.75	200238.0
2008-07-24 08:00:00	IWM	ETF	71.76	71.8	71.6	71.71	871141.0
2008-07-24 09:00:00	IWM	ETF	71.72	71.96	71.31	71.44	9313046.0
2008-07-24 10:00:00	IWM	ETF	71.44	71.57	71.05	71.2	15378651.0
2008-07-24 11:00:00	IWM	ETF	71.2	71.31	70.72	71.11	13711745.0
2008-07-24 12:00:00	IWM	ETF	71.12	71.19	70.71	70.86	7879273.0
2008-07-24 13:00:00	IWM	ETF	70.86	71.13	70.64	70.68	11541299.0
2008-07-24 14:00:00	IWM	ETF	70.68	70.73	70.28	70.49	13921795.0
2008-07-24 15:00:00	IWM	ETF	70.49	70.7	69.86	70.08	24908232.0
2008-07-24 16:00:00	IWM	ETF	70.09	71.71	70.03	71.71	3845453.0
2008-07-24 17:00:00	IWM	ETF	70.35	71.71	70.33	70.4	1036987.0
2008-07-24 18:00:00	IWM	ETF	70.36	70.45	70.36	70.43	42400.0
2008-07-24 19:00:00	IWM	ETF	70.35	70.35	70.35	70.35	1300.0
2008-07-24 07:00:00	DIA	ETF	115.72	115.9	115.65	115.9	30754.0
2008-07-24 08:00:00	DIA	ETF	115.92	116.02	115.52	115.94	98139.0
2008-07-24 09:00:00	DIA	ETF	116.0	116.3	115.34	115.41	2291720.0
2008-07-24 10:00:00	DIA	ETF	115.41	115.41	114.85	115.18	4286561.0
2008-07-24 11:00:00	DIA	ETF	115.18	115.28	114.72	115.03	3217983.0

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

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