PREVIEW / etf_30min / 2008-09-08

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-09-08.parquet
  size:    182 KB
  rows:    6,266

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.28	128.2	128.2	4575.0
2008-09-08 04:30:00	SPY	ETF	128.38	128.4	128.0	128.0	1800.0
2008-09-08 05:00:00	SPY	ETF	128.07	128.2	128.07	128.11	4900.0
2008-09-08 05:30:00	SPY	ETF	128.13	128.14	127.94	128.05	21100.0
2008-09-08 06:00:00	SPY	ETF	128.06	128.32	128.06	128.14	8700.0
2008-09-08 06:30:00	SPY	ETF	128.12	128.32	128.07	128.3	189775.0
2008-09-08 07:00:00	SPY	ETF	128.25	128.32	127.74	127.77	1087853.0
2008-09-08 07:30:00	SPY	ETF	127.76	127.99	127.6	127.97	1628848.0
2008-09-08 08:00:00	SPY	ETF	127.95	128.3	127.16	128.13	5906231.0
2008-09-08 08:30:00	SPY	ETF	128.13	128.62	128.12	128.18	4146088.0
2008-09-08 09:00:00	SPY	ETF	128.18	128.29	127.91	128.05	3687784.0
2008-09-08 09:30:00	SPY	ETF	128.04	128.24	126.85	126.88	49025581.0
2008-09-08 10:00:00	SPY	ETF	126.87	127.4	126.66	126.96	34913351.0
2008-09-08 10:30:00	SPY	ETF	126.97	127.58	126.33	126.35	30948078.0
2008-09-08 11:00:00	SPY	ETF	126.36	128.0	125.49	126.1	45146312.0
2008-09-08 11:30:00	SPY	ETF	126.09	127.0	125.41	125.82	25694469.0
2008-09-08 12:00:00	SPY	ETF	125.82	125.99	125.09	125.77	24416132.0
2008-09-08 12:30:00	SPY	ETF	125.77	126.4	125.72	126.26	18044320.0
2008-09-08 13:00:00	SPY	ETF	126.26	126.39	125.67	126.0	10899498.0
2008-09-08 13:30:00	SPY	ETF	126.0	126.09	125.22	125.33	12993374.0
2008-09-08 14:00:00	SPY	ETF	125.32	126.18	125.19	126.14	18416055.0
2008-09-08 14:30:00	SPY	ETF	126.14	126.44	125.85	126.02	15964681.0
2008-09-08 15:00:00	SPY	ETF	126.02	126.7	125.6	126.645	18722107.0
2008-09-08 15:30:00	SPY	ETF	126.63	127.25	126.6	127.25	32531927.0
2008-09-08 16:00:00	SPY	ETF	127.245	127.44	124.6678	127.21	5450864.0
2008-09-08 16:30:00	SPY	ETF	127.11	127.13	126.97	127.02	1403939.0
2008-09-08 17:00:00	SPY	ETF	127.04	127.06	126.99	127.04	45307.0
2008-09-08 17:30:00	SPY	ETF	127.05	127.06	127.0	127.04	18035.0
2008-09-08 18:00:00	SPY	ETF	127.04	127.1	126.98	127.1	30403.0
2008-09-08 18:30:00	SPY	ETF	127.15	127.15	127.07	127.1	10000.0
2008-09-08 19:00:00	SPY	ETF	127.11	127.12	127.09	127.09	1867.0
2008-09-08 19:30:00	SPY	ETF	127.12	127.15	126.97	126.97	8300.0
2008-09-08 04:00:00	QQQ	ETF	44.56	44.6	44.55	44.56	7536.0
2008-09-08 04:30:00	QQQ	ETF	44.57	44.57	44.45	44.45	2400.0
2008-09-08 05:00:00	QQQ	ETF	44.42	44.44	44.42	44.44	800.0
2008-09-08 05:30:00	QQQ	ETF	44.39	44.39	44.39	44.39	5000.0
2008-09-08 06:00:00	QQQ	ETF	44.41	44.54	44.41	44.45	11000.0
2008-09-08 06:30:00	QQQ	ETF	44.44	44.5	44.44	44.49	72850.0
2008-09-08 07:00:00	QQQ	ETF	44.47	44.49	44.33	44.37	308593.0
2008-09-08 07:30:00	QQQ	ETF	44.35	44.43	44.28	44.43	359664.0
2008-09-08 08:00:00	QQQ	ETF	44.4	44.55	44.37	44.44	4661956.0
2008-09-08 08:30:00	QQQ	ETF	44.44	44.51	44.33	44.34	2678496.0
2008-09-08 09:00:00	QQQ	ETF	44.34	44.35	44.04	44.04	4072228.0
2008-09-08 09:30:00	QQQ	ETF	44.04	44.22	43.55	43.551	45799263.0
2008-09-08 10:00:00	QQQ	ETF	43.56	43.78	43.39	43.54	29520885.0
2008-09-08 10:30:00	QQQ	ETF	43.54	43.89	43.31	43.31	26702725.0
2008-09-08 11:00:00	QQQ	ETF	43.3101	43.49	43.03	43.14	26344549.0
2008-09-08 11:30:00	QQQ	ETF	43.15	43.34	42.88	42.99	20472881.0
2008-09-08 12:00:00	QQQ	ETF	42.99	43.06	42.68	43.0199	20789560.0
2008-09-08 12:30:00	QQQ	ETF	43.01	43.3	43.01	43.22	14471599.0

> showing 50 of 6,266 rows — these rows as CSV

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