PREVIEW / etf_30min / 2008-01-16

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-01-16.parquet
  size:    163 KB
  rows:    5,879

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-01-16 04:00:00	SPY	ETF	137.1	137.2	137.1	137.2	4000.0
2008-01-16 04:30:00	SPY	ETF	137.36	137.36	137.35	137.35	2000.0
2008-01-16 05:00:00	SPY	ETF	137.35	137.35	137.04	137.04	5000.0
2008-01-16 05:30:00	SPY	ETF	137.05	137.1	136.9	137.0	25600.0
2008-01-16 06:00:00	SPY	ETF	137.08	137.1	137.0	137.0	50000.0
2008-01-16 06:30:00	SPY	ETF	136.88	136.92	136.6	136.92	120200.0
2008-01-16 07:00:00	SPY	ETF	136.95	137.22	136.82	137.14	998200.0
2008-01-16 07:30:00	SPY	ETF	137.14	137.49	137.1	137.1	1482400.0
2008-01-16 08:00:00	SPY	ETF	137.0	137.68	136.6664	137.57	7408700.0
2008-01-16 08:30:00	SPY	ETF	137.53	137.64	136.88	137.26	6413200.0
2008-01-16 09:00:00	SPY	ETF	137.28	137.77	137.17	137.36	5451605.0
2008-01-16 09:30:00	SPY	ETF	137.37	138.5	137.3	137.45	32233753.0
2008-01-16 10:00:00	SPY	ETF	137.45	137.75	136.94	137.22	20626987.0
2008-01-16 10:30:00	SPY	ETF	137.2	137.47	136.28	136.65	29160737.0
2008-01-16 11:00:00	SPY	ETF	136.65	137.6	136.59	137.4	23544388.0
2008-01-16 11:30:00	SPY	ETF	137.4	138.08	136.8	137.9	28346340.0
2008-01-16 12:00:00	SPY	ETF	137.9	138.23	137.55	137.77	17180670.0
2008-01-16 12:30:00	SPY	ETF	137.77	138.33	137.63	137.79	14238831.0
2008-01-16 13:00:00	SPY	ETF	137.79	137.95	137.32	137.36	14307099.0
2008-01-16 13:30:00	SPY	ETF	137.37	137.9	137.26	137.51	14857842.0
2008-01-16 14:00:00	SPY	ETF	137.51	138.51	137.13	138.47	28342625.0
2008-01-16 14:30:00	SPY	ETF	138.47	139.12	138.1	138.18	40854599.0
2008-01-16 15:00:00	SPY	ETF	138.19	138.91	138.04	138.59	30416826.0
2008-01-16 15:30:00	SPY	ETF	138.59	138.8	137.1	137.15	37187270.0
2008-01-16 16:00:00	SPY	ETF	137.16	138.24	136.98	137.1	3229900.0
2008-01-16 16:30:00	SPY	ETF	137.12	137.9824	137.12	137.28	18065750.0
2008-01-16 17:00:00	SPY	ETF	137.27	137.36	137.2	137.27	47500.0
2008-01-16 17:30:00	SPY	ETF	137.26	137.31	137.2	137.21	60100.0
2008-01-16 18:00:00	SPY	ETF	137.26	137.28	137.11	137.28	22700.0
2008-01-16 18:30:00	SPY	ETF	137.2	137.31	137.15	137.3	42300.0
2008-01-16 19:00:00	SPY	ETF	137.31	137.41	137.3	137.3	19300.0
2008-01-16 19:30:00	SPY	ETF	137.41	137.51	137.37	137.4	10200.0
2008-01-16 04:00:00	QQQ	ETF	46.03	46.03	46.03	46.03	1200.0
2008-01-16 04:30:00	QQQ	ETF	46.01	46.01	46.01	46.01	100.0
2008-01-16 05:00:00	QQQ	ETF	46.01	46.01	46.01	46.01	300.0
2008-01-16 05:30:00	QQQ	ETF	45.94	45.94	45.94	45.94	100.0
2008-01-16 06:00:00	QQQ	ETF	45.97	45.97	45.97	45.97	1200.0
2008-01-16 06:30:00	QQQ	ETF	45.83	45.95	45.83	45.95	27700.0
2008-01-16 07:00:00	QQQ	ETF	45.96	46.1	45.93	46.1	1156539.0
2008-01-16 07:30:00	QQQ	ETF	46.11	46.17	46.04	46.04	985098.0
2008-01-16 08:00:00	QQQ	ETF	46.07	46.26	46.0	46.26	3135641.0
2008-01-16 08:30:00	QQQ	ETF	46.26	46.26	46.03	46.1	3546147.0
2008-01-16 09:00:00	QQQ	ETF	46.14	46.31	46.1	46.19	2266218.0
2008-01-16 09:30:00	QQQ	ETF	46.19	46.65	46.11	46.15	27789960.0
2008-01-16 10:00:00	QQQ	ETF	46.15	46.2	45.84	45.8801	20423771.0
2008-01-16 10:30:00	QQQ	ETF	45.88	46.05	45.46	45.63	19918754.0
2008-01-16 11:00:00	QQQ	ETF	45.64	46.07	45.62	46.06	24244889.0
2008-01-16 11:30:00	QQQ	ETF	46.06	46.3	45.77	46.25	18688334.0
2008-01-16 12:00:00	QQQ	ETF	46.26	46.38	46.09	46.22	14962453.0
2008-01-16 12:30:00	QQQ	ETF	46.22	46.47	46.21	46.3	12491572.0

> showing 50 of 5,879 rows — these rows as CSV

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