PREVIEW / etf_30min / 2010-05-17

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-05-17.parquet
  size:    269 KB
  rows:    8,985

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-05-17 04:00:00	SPY	ETF	113.63	113.72	113.53	113.53	900.0
2010-05-17 04:30:00	SPY	ETF	113.76	113.84	113.68	113.76	900.0
2010-05-17 05:00:00	SPY	ETF	114.01	114.27	114.01	114.17	11000.0
2010-05-17 05:30:00	SPY	ETF	114.09	114.09	114.03	114.03	6986.0
2010-05-17 06:00:00	SPY	ETF	113.99	114.16	113.99	114.16	11030.0
2010-05-17 06:30:00	SPY	ETF	114.16	114.38	114.14	114.14	156400.0
2010-05-17 07:00:00	SPY	ETF	114.11	114.46	114.09	114.46	330041.0
2010-05-17 07:30:00	SPY	ETF	114.45	114.46	114.23	114.3	216796.0
2010-05-17 08:00:00	SPY	ETF	114.28	114.33	112.6	113.62	3307391.0
2010-05-17 08:30:00	SPY	ETF	113.6	114.26	113.47	113.9	1930655.0
2010-05-17 09:00:00	SPY	ETF	113.9	114.29	113.84	114.18	2077397.0
2010-05-17 09:30:00	SPY	ETF	114.2	114.52	113.57	113.71	27834244.0
2010-05-17 10:00:00	SPY	ETF	113.7	114.08	113.52	113.92	23268447.0
2010-05-17 10:30:00	SPY	ETF	113.93	114.12	113.53	113.53	14540096.0
2010-05-17 11:00:00	SPY	ETF	113.53	113.75	112.76	113.06	25626277.0
2010-05-17 11:30:00	SPY	ETF	113.05	113.285	112.61	112.6475	12994451.0
2010-05-17 12:00:00	SPY	ETF	112.65	112.65	111.77	112.21	35347045.0
2010-05-17 12:30:00	SPY	ETF	112.21	112.56	112.2	112.23	15966006.0
2010-05-17 13:00:00	SPY	ETF	112.23	112.86	112.19	112.71	17312268.0
2010-05-17 13:30:00	SPY	ETF	112.71	112.95	112.33	112.76	17824462.0
2010-05-17 14:00:00	SPY	ETF	112.76	113.07	112.69	112.8	19352499.0
2010-05-17 14:30:00	SPY	ETF	112.79	113.45	112.72	113.4	20614701.0
2010-05-17 15:00:00	SPY	ETF	113.4	113.77	112.86	113.2	30007757.0
2010-05-17 15:30:00	SPY	ETF	113.19	114.15	113.16	113.95	40701193.0
2010-05-17 16:00:00	SPY	ETF	113.95	114.05	111.91	114.05	6811317.0
2010-05-17 16:30:00	SPY	ETF	114.06	114.27	113.95	114.17	513784.0
2010-05-17 17:00:00	SPY	ETF	114.15	114.17	114.07	114.09	87621.0
2010-05-17 17:30:00	SPY	ETF	114.15	114.15	114.08	114.14	23740.0
2010-05-17 18:00:00	SPY	ETF	114.11	114.19	114.08	114.13	121810.0
2010-05-17 18:30:00	SPY	ETF	114.15	114.25	114.15	114.19	48935.0
2010-05-17 19:00:00	SPY	ETF	114.16	114.17	114.03	114.06	30780.0
2010-05-17 19:30:00	SPY	ETF	114.06	114.15	114.01	114.13	43763.0
2010-05-17 04:00:00	QQQ	ETF	46.89	46.89	46.89	46.89	100.0
2010-05-17 04:30:00	QQQ	ETF	46.92	46.92	46.92	46.92	500.0
2010-05-17 05:00:00	QQQ	ETF	47.0	47.08	47.0	47.08	2300.0
2010-05-17 05:30:00	QQQ	ETF	47.06	47.09	47.01	47.01	6600.0
2010-05-17 06:00:00	QQQ	ETF	47.09	47.09	47.09	47.09	100.0
2010-05-17 06:30:00	QQQ	ETF	47.1	47.1	47.05	47.08	5352.0
2010-05-17 07:00:00	QQQ	ETF	47.05	47.19	47.04	47.19	18126.0
2010-05-17 07:30:00	QQQ	ETF	47.17	47.18	47.1	47.14	70659.0
2010-05-17 08:00:00	QQQ	ETF	47.15	47.17	46.35	46.86	655778.0
2010-05-17 08:30:00	QQQ	ETF	46.84	47.13	46.8	46.93	759040.0
2010-05-17 09:00:00	QQQ	ETF	46.94	47.06	46.91	47.04	454110.0
2010-05-17 09:30:00	QQQ	ETF	47.04	47.27	46.84	46.92	12480052.0
2010-05-17 10:00:00	QQQ	ETF	46.92	47.18	46.86	47.12	7719241.0
2010-05-17 10:30:00	QQQ	ETF	47.13	47.23	46.96	46.96	6128806.0
2010-05-17 11:00:00	QQQ	ETF	46.96	47.0	46.57	46.66	7403361.0
2010-05-17 11:30:00	QQQ	ETF	46.66	46.77	46.5	46.51	5275133.0
2010-05-17 12:00:00	QQQ	ETF	46.5	46.5	46.07	46.32	14992174.0
2010-05-17 12:30:00	QQQ	ETF	46.33	46.49	46.28	46.3	7819248.0

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

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