PREVIEW / etf_30min / 2010-03-17

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-03-17.parquet
  size:    254 KB
  rows:    8,590

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
2010-03-17 04:00:00	SPY	ETF	116.61	116.67	116.61	116.67	500.0
2010-03-17 04:30:00	SPY	ETF	116.72	116.72	116.69	116.7	1800.0
2010-03-17 05:30:00	SPY	ETF	116.63	116.72	116.63	116.72	7684.0
2010-03-17 06:00:00	SPY	ETF	116.77	116.77	116.75	116.75	2464.0
2010-03-17 06:30:00	SPY	ETF	116.77	116.85	116.76	116.8	43336.0
2010-03-17 07:00:00	SPY	ETF	116.8	116.82	116.75	116.75	105475.0
2010-03-17 07:30:00	SPY	ETF	116.78	116.78	116.65	116.65	233990.0
2010-03-17 08:00:00	SPY	ETF	116.66	116.69	116.54	116.62	863253.0
2010-03-17 08:30:00	SPY	ETF	116.64	116.73	116.59	116.71	1076838.0
2010-03-17 09:00:00	SPY	ETF	116.72	116.78	116.66	116.75	1068552.0
2010-03-17 09:30:00	SPY	ETF	116.76	117.06	116.71	117.03	18767672.0
2010-03-17 10:00:00	SPY	ETF	117.03	117.09	116.83	116.84	13162568.0
2010-03-17 10:30:00	SPY	ETF	116.85	116.99	116.81	116.9874	16064219.0
2010-03-17 11:00:00	SPY	ETF	116.99	117.2	116.93	117.13	12095543.0
2010-03-17 11:30:00	SPY	ETF	117.12	117.22	117.04	117.08	8611606.0
2010-03-17 12:00:00	SPY	ETF	117.08	117.15	116.95	117.07	6023254.0
2010-03-17 12:30:00	SPY	ETF	117.07	117.15	117.025	117.12	5022477.0
2010-03-17 13:00:00	SPY	ETF	117.13	117.3	117.11	117.24	7414777.0
2010-03-17 13:30:00	SPY	ETF	117.24	117.48	117.24	117.36	13884519.0
2010-03-17 14:00:00	SPY	ETF	117.36	117.45	117.31	117.37	5838150.0
2010-03-17 14:30:00	SPY	ETF	117.37	117.4	116.96	116.96	16660326.0
2010-03-17 15:00:00	SPY	ETF	116.97	117.13	116.73	116.86	16794769.0
2010-03-17 15:30:00	SPY	ETF	116.86	117.11	116.75	117.1	18632694.0
2010-03-17 16:00:00	SPY	ETF	117.11	117.17	116.4182	117.06	4247784.0
2010-03-17 16:30:00	SPY	ETF	117.05	117.25	117.01	117.25	6273279.0
2010-03-17 17:00:00	SPY	ETF	117.17	117.18	116.4197	117.08	2694013.0
2010-03-17 17:30:00	SPY	ETF	117.07	117.15	117.07	117.1	94506.0
2010-03-17 18:00:00	SPY	ETF	117.11	117.17	117.11	117.15	120171.0
2010-03-17 18:30:00	SPY	ETF	117.11	117.13	117.1	117.1	23150.0
2010-03-17 19:00:00	SPY	ETF	117.1	117.24	117.1	117.21	29200.0
2010-03-17 19:30:00	SPY	ETF	117.2	117.32	117.18	117.28	92547.0
2010-03-17 06:30:00	QQQ	ETF	47.63	47.64	47.63	47.64	600.0
2010-03-17 07:00:00	QQQ	ETF	47.65	47.65	47.65	47.65	600.0
2010-03-17 07:30:00	QQQ	ETF	47.63	47.63	47.6	47.6	12280.0
2010-03-17 08:00:00	QQQ	ETF	47.6	47.69	47.55	47.58	903464.0
2010-03-17 08:30:00	QQQ	ETF	47.57	47.61	47.57	47.59	223488.0
2010-03-17 09:00:00	QQQ	ETF	47.59	47.61	47.57	47.61	842256.0
2010-03-17 09:30:00	QQQ	ETF	47.6	47.76	47.59	47.72	9930973.0
2010-03-17 10:00:00	QQQ	ETF	47.73	47.75	47.65	47.69	7578138.0
2010-03-17 10:30:00	QQQ	ETF	47.69	47.73	47.67	47.73	2792151.0
2010-03-17 11:00:00	QQQ	ETF	47.725	47.81	47.7	47.76	3947840.0
2010-03-17 11:30:00	QQQ	ETF	47.76	47.79	47.72	47.7462	2634503.0
2010-03-17 12:00:00	QQQ	ETF	47.75	47.79	47.74	47.76	1739000.0
2010-03-17 12:30:00	QQQ	ETF	47.76	47.77	47.73	47.77	1834446.0
2010-03-17 13:00:00	QQQ	ETF	47.7675	47.82	47.75	47.81	1677242.0
2010-03-17 13:30:00	QQQ	ETF	47.8	47.9	47.5583	47.8299	7498998.0
2010-03-17 14:00:00	QQQ	ETF	47.83	47.845	47.78	47.78	1989861.0
2010-03-17 14:30:00	QQQ	ETF	47.78	47.79	47.59	47.6	5269984.0
2010-03-17 15:00:00	QQQ	ETF	47.5901	47.66	47.53	47.6074	5080526.0
2010-03-17 15:30:00	QQQ	ETF	47.6	47.69	47.53	47.66	7060492.0

> showing 50 of 8,590 rows — these rows as CSV

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