PREVIEW / etf_1hour / 2008-09-08

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-09-08.parquet
  size:    114 KB
  rows:    3,697

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-08 04:00:00	SPY	ETF	128.28	128.4	128.0	128.0	6375.0
2008-09-08 05:00:00	SPY	ETF	128.07	128.2	127.94	128.05	26000.0
2008-09-08 06:00:00	SPY	ETF	128.06	128.32	128.06	128.3	198475.0
2008-09-08 07:00:00	SPY	ETF	128.25	128.32	127.6	127.97	2716701.0
2008-09-08 08:00:00	SPY	ETF	127.95	128.62	127.16	128.18	10052319.0
2008-09-08 09:00:00	SPY	ETF	128.18	128.29	126.85	126.88	52713365.0
2008-09-08 10:00:00	SPY	ETF	126.87	127.58	126.33	126.35	65861429.0
2008-09-08 11:00:00	SPY	ETF	126.36	128.0	125.41	125.82	70840781.0
2008-09-08 12:00:00	SPY	ETF	125.82	126.4	125.09	126.26	42460452.0
2008-09-08 13:00:00	SPY	ETF	126.26	126.39	125.22	125.33	23892872.0
2008-09-08 14:00:00	SPY	ETF	125.32	126.44	125.19	126.02	34380736.0
2008-09-08 15:00:00	SPY	ETF	126.02	127.25	125.6	127.25	51254034.0
2008-09-08 16:00:00	SPY	ETF	127.245	127.44	124.6678	127.02	6854803.0
2008-09-08 17:00:00	SPY	ETF	127.04	127.06	126.99	127.04	63342.0
2008-09-08 18:00:00	SPY	ETF	127.04	127.15	126.98	127.1	40403.0
2008-09-08 19:00:00	SPY	ETF	127.11	127.15	126.97	126.97	10167.0
2008-09-08 04:00:00	QQQ	ETF	44.56	44.6	44.45	44.45	9936.0
2008-09-08 05:00:00	QQQ	ETF	44.42	44.44	44.39	44.39	5800.0
2008-09-08 06:00:00	QQQ	ETF	44.41	44.54	44.41	44.49	83850.0
2008-09-08 07:00:00	QQQ	ETF	44.47	44.49	44.28	44.43	668257.0
2008-09-08 08:00:00	QQQ	ETF	44.4	44.55	44.33	44.34	7340452.0
2008-09-08 09:00:00	QQQ	ETF	44.34	44.35	43.55	43.551	49871491.0
2008-09-08 10:00:00	QQQ	ETF	43.56	43.89	43.31	43.31	56223610.0
2008-09-08 11:00:00	QQQ	ETF	43.3101	43.49	42.88	42.99	46817430.0
2008-09-08 12:00:00	QQQ	ETF	42.99	43.3	42.68	43.22	35261159.0
2008-09-08 13:00:00	QQQ	ETF	43.23	43.25	42.78	42.81	19342944.0
2008-09-08 14:00:00	QQQ	ETF	42.81	43.29	42.75	43.15	25262863.0
2008-09-08 15:00:00	QQQ	ETF	43.14	43.52	42.96	43.3797	37734474.0
2008-09-08 16:00:00	QQQ	ETF	43.38	43.66	43.26	43.26	13037459.0
2008-09-08 17:00:00	QQQ	ETF	43.26	43.37	43.26	43.33	154476.0
2008-09-08 18:00:00	QQQ	ETF	43.31	43.34	43.28	43.29	35867.0
2008-09-08 19:00:00	QQQ	ETF	43.3	43.34	43.29	43.29	7428.0
2008-09-08 04:00:00	IWM	ETF	74.06	74.06	74.06	74.06	200.0
2008-09-08 05:00:00	IWM	ETF	74.06	74.06	74.01	74.05	2200.0
2008-09-08 06:00:00	IWM	ETF	74.1	74.15	74.0	74.12	14100.0
2008-09-08 07:00:00	IWM	ETF	74.35	74.48	73.88	74.05	285562.0
2008-09-08 08:00:00	IWM	ETF	74.11	74.37	74.01	74.27	1288755.0
2008-09-08 09:00:00	IWM	ETF	74.27	74.35	73.2	73.22	20249690.0
2008-09-08 10:00:00	IWM	ETF	73.22	73.63	71.64	72.8	25014964.0
2008-09-08 11:00:00	IWM	ETF	72.8	73.24	72.29	72.63	21942562.0
2008-09-08 12:00:00	IWM	ETF	72.63	72.88	72.28	72.74	13867080.0
2008-09-08 13:00:00	IWM	ETF	72.73	72.81	72.23	72.28	9160304.0
2008-09-08 14:00:00	IWM	ETF	72.27	72.95	72.16	72.78	14754513.0
2008-09-08 15:00:00	IWM	ETF	72.78	73.31	72.47	73.24	24789210.0
2008-09-08 16:00:00	IWM	ETF	73.24	73.5	71.79	73.27	15269177.0
2008-09-08 17:00:00	IWM	ETF	73.27	73.27	73.2	73.2	16419.0
2008-09-08 18:00:00	IWM	ETF	73.21	73.3	73.21	73.3	9567.0
2008-09-08 06:00:00	DIA	ETF	114.91	115.23	114.91	115.23	9600.0
2008-09-08 07:00:00	DIA	ETF	115.13	115.14	114.7	114.94	67382.0
2008-09-08 08:00:00	DIA	ETF	114.94	115.36	114.92	115.29	291324.0

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

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