PREVIEW / etf_30min / 2012-06-04

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-06-04.parquet
  size:    296 KB
  rows:    10,137

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
2012-06-04 04:00:00	SPY	ETF	127.65	127.65	127.36	127.41	6200.0
2012-06-04 04:30:00	SPY	ETF	127.41	127.49	127.41	127.49	1800.0
2012-06-04 05:00:00	SPY	ETF	127.49	127.65	127.49	127.64	12388.0
2012-06-04 05:30:00	SPY	ETF	127.6	127.75	127.55	127.7	7310.0
2012-06-04 06:00:00	SPY	ETF	127.72	128.03	127.69	128.0	31736.0
2012-06-04 06:30:00	SPY	ETF	127.95	128.31	127.92	128.21	284490.0
2012-06-04 07:00:00	SPY	ETF	128.15	128.33	128.13	128.17	301683.0
2012-06-04 07:30:00	SPY	ETF	128.17	128.43	128.1	128.35	575144.0
2012-06-04 08:00:00	SPY	ETF	128.33	128.44	128.12	128.35	3438350.0
2012-06-04 08:30:00	SPY	ETF	128.35	128.35	127.19	128.33	538403.0
2012-06-04 09:00:00	SPY	ETF	128.33	128.54	127.11	128.4	2995380.0
2012-06-04 09:30:00	SPY	ETF	128.39	128.74	127.84	127.97	22191915.0
2012-06-04 10:00:00	SPY	ETF	127.98	128.21	127.55	128.04	23004185.0
2012-06-04 10:30:00	SPY	ETF	128.0401	128.28	127.8	128.1	13376401.0
2012-06-04 11:00:00	SPY	ETF	128.1	128.15	127.71	127.74	8211004.0
2012-06-04 11:30:00	SPY	ETF	127.73	127.88	127.62	127.66	6629699.0
2012-06-04 12:00:00	SPY	ETF	127.66	127.76	127.19	127.23	9113937.0
2012-06-04 12:30:00	SPY	ETF	127.23	127.45	127.17	127.35	6820715.0
2012-06-04 13:00:00	SPY	ETF	127.35	127.55	127.135	127.25	9543891.0
2012-06-04 13:30:00	SPY	ETF	127.25	127.67	127.2	127.558	9342850.0
2012-06-04 14:00:00	SPY	ETF	127.57	128.12	127.45	128.1	10830679.0
2012-06-04 14:30:00	SPY	ETF	128.099	128.51	127.95	128.075	13881681.0
2012-06-04 15:00:00	SPY	ETF	128.075	128.21	127.75	128.07	11840057.0
2012-06-04 15:30:00	SPY	ETF	128.07	128.4	127.73	128.17	21410773.0
2012-06-04 16:00:00	SPY	ETF	128.18	128.38	127.68	127.89	10683621.0
2012-06-04 16:30:00	SPY	ETF	127.9	127.99	127.84	127.99	5477534.0
2012-06-04 17:00:00	SPY	ETF	127.98	127.99	127.8	127.85	173756.0
2012-06-04 17:30:00	SPY	ETF	127.82	127.91	127.82	127.87	33661.0
2012-06-04 18:00:00	SPY	ETF	127.88	127.97	127.88	127.95	91288.0
2012-06-04 18:30:00	SPY	ETF	127.95	128.06	127.93	128.03	38340.0
2012-06-04 19:00:00	SPY	ETF	128.02	128.05	127.99	128.0	8581.0
2012-06-04 19:30:00	SPY	ETF	128.0	128.15	128.0	128.15	92504.0
2012-06-04 04:00:00	QQQ	ETF	60.2	60.2	60.05	60.09	1380.0
2012-06-04 05:00:00	QQQ	ETF	60.19	60.19	60.19	60.19	600.0
2012-06-04 06:00:00	QQQ	ETF	60.35	60.35	60.35	60.35	300.0
2012-06-04 06:30:00	QQQ	ETF	60.34	60.34	60.34	60.34	500.0
2012-06-04 07:00:00	QQQ	ETF	60.44	60.56	60.44	60.46	807096.0
2012-06-04 07:30:00	QQQ	ETF	60.47	60.58	60.44	60.5	1198850.0
2012-06-04 08:00:00	QQQ	ETF	60.49	60.6	60.44	60.53	4246162.0
2012-06-04 08:30:00	QQQ	ETF	60.53	60.54	60.45	60.52	254260.0
2012-06-04 09:00:00	QQQ	ETF	60.52	60.62	59.8822	60.58	2427240.0
2012-06-04 09:30:00	QQQ	ETF	60.57	60.96	60.3	60.36	10418928.0
2012-06-04 10:00:00	QQQ	ETF	60.37	60.61	60.04	60.5	8025108.0
2012-06-04 10:30:00	QQQ	ETF	60.51	60.69	60.38	60.52	3327879.0
2012-06-04 11:00:00	QQQ	ETF	60.52	60.55	60.28	60.28	2133428.0
2012-06-04 11:30:00	QQQ	ETF	60.28	60.39	60.22	60.22	1339583.0
2012-06-04 12:00:00	QQQ	ETF	60.22	60.3	60.06	60.09	2307752.0
2012-06-04 12:30:00	QQQ	ETF	60.1	60.25	60.06	60.19	1711420.0
2012-06-04 13:00:00	QQQ	ETF	60.2	60.36	60.05	60.13	2627409.0
2012-06-04 13:30:00	QQQ	ETF	60.14	60.35	60.09	60.34	2192224.0

> showing 50 of 10,137 rows — these rows as CSV

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