PREVIEW / etf_1hour / 2008-07-29

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-07-29.parquet
  size:    107 KB
  rows:    3,430

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-29 04:00:00	SPY	ETF	123.84	123.84	123.84	123.84	100.0
2008-07-29 05:00:00	SPY	ETF	123.92	123.92	123.92	123.92	100.0
2008-07-29 06:00:00	SPY	ETF	123.28	123.58	123.28	123.55	27100.0
2008-07-29 07:00:00	SPY	ETF	123.74	124.2	123.67	124.17	1551519.0
2008-07-29 08:00:00	SPY	ETF	124.17	124.29	123.51	124.05	1986583.0
2008-07-29 09:00:00	SPY	ETF	124.05	124.5	123.84	124.49	28602973.0
2008-07-29 10:00:00	SPY	ETF	124.49	125.13	124.43	124.909	54509957.0
2008-07-29 11:00:00	SPY	ETF	124.9	125.34	124.68	125.18	29375441.0
2008-07-29 12:00:00	SPY	ETF	125.19	125.41	125.04	125.34	29265934.0
2008-07-29 13:00:00	SPY	ETF	125.33	125.75	125.13	125.71	20383839.0
2008-07-29 14:00:00	SPY	ETF	125.71	125.76	125.06	125.42	36170948.0
2008-07-29 15:00:00	SPY	ETF	125.42	126.3	125.21	126.27	44617155.0
2008-07-29 16:00:00	SPY	ETF	126.27	126.37	124.95	126.27	10203932.0
2008-07-29 17:00:00	SPY	ETF	126.24	126.37	126.21	126.27	588894.0
2008-07-29 18:00:00	SPY	ETF	126.3	126.38	126.25	126.25	27396.0
2008-07-29 19:00:00	SPY	ETF	126.26	126.27	126.25	126.26	62683.0
2008-07-29 05:00:00	QQQ	ETF	44.56	44.56	44.56	44.56	400.0
2008-07-29 06:00:00	QQQ	ETF	44.42	44.42	44.4	44.4	50100.0
2008-07-29 07:00:00	QQQ	ETF	44.51	44.72	44.5	44.7	81120.0
2008-07-29 08:00:00	QQQ	ETF	44.7	44.72	44.63	44.66	1359264.0
2008-07-29 09:00:00	QQQ	ETF	44.66	44.94	44.57	44.9	19401414.0
2008-07-29 10:00:00	QQQ	ETF	44.9	45.54	44.89	45.43	36625844.0
2008-07-29 11:00:00	QQQ	ETF	45.4219	45.5	45.27	45.4	12834270.0
2008-07-29 12:00:00	QQQ	ETF	45.4	45.5	45.17	45.24	16904642.0
2008-07-29 13:00:00	QQQ	ETF	45.2399	45.43	45.17	45.3601	6771756.0
2008-07-29 14:00:00	QQQ	ETF	45.3601	45.38	45.12	45.2399	13504441.0
2008-07-29 15:00:00	QQQ	ETF	45.24	45.44	45.185	45.35	22114307.0
2008-07-29 16:00:00	QQQ	ETF	45.331	45.43	45.2	45.22	3778002.0
2008-07-29 17:00:00	QQQ	ETF	45.22	45.26	44.3335	45.23	1601353.0
2008-07-29 18:00:00	QQQ	ETF	45.25	45.28	45.23	45.24	48050.0
2008-07-29 19:00:00	QQQ	ETF	45.24	45.26	45.22	45.26	5245.0
2008-07-29 05:00:00	IWM	ETF	69.71	69.71	69.71	69.71	1000.0
2008-07-29 07:00:00	IWM	ETF	69.55	69.84	69.55	69.82	178056.0
2008-07-29 08:00:00	IWM	ETF	69.82	69.92	69.7	69.78	628905.0
2008-07-29 09:00:00	IWM	ETF	69.78	70.38	69.6	70.28	12635210.0
2008-07-29 10:00:00	IWM	ETF	70.29	70.92	70.27	70.77	24972975.0
2008-07-29 11:00:00	IWM	ETF	70.79	71.02	70.57	70.85	11305502.0
2008-07-29 12:00:00	IWM	ETF	70.85	71.07	70.77	70.98	12940384.0
2008-07-29 13:00:00	IWM	ETF	70.98	71.4	70.87	71.29	8869874.0
2008-07-29 14:00:00	IWM	ETF	71.29	71.33	70.8	71.0	11462885.0
2008-07-29 15:00:00	IWM	ETF	71.01	71.29	70.94	71.26	18688400.0
2008-07-29 16:00:00	IWM	ETF	71.26	71.29	69.42	71.22	6654560.0
2008-07-29 17:00:00	IWM	ETF	71.22	71.22	71.21	71.21	769.0
2008-07-29 18:00:00	IWM	ETF	71.21	71.27	71.21	71.27	832.0
2008-07-29 19:00:00	IWM	ETF	71.21	71.21	71.18	71.19	500.0
2008-07-29 07:00:00	DIA	ETF	111.66	111.8	111.66	111.8	4625.0
2008-07-29 08:00:00	DIA	ETF	111.8	111.88	111.7	111.71	46141.0
2008-07-29 09:00:00	DIA	ETF	111.72	112.17	111.51	112.16	2369885.0
2008-07-29 10:00:00	DIA	ETF	112.16	112.68	111.65	112.54	3705927.0
2008-07-29 11:00:00	DIA	ETF	112.54	112.9	112.35	112.83	2012677.0

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

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