PREVIEW / etf_30min / 2012-06-05

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-06-05.parquet
  size:    281 KB
  rows:    9,470

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-05 04:00:00	SPY	ETF	128.29	128.29	127.96	127.96	1424.0
2012-06-05 04:30:00	SPY	ETF	127.91	127.91	127.54	127.69	2924.0
2012-06-05 05:00:00	SPY	ETF	127.75	127.84	127.71	127.8	17230.0
2012-06-05 05:30:00	SPY	ETF	127.69	127.71	127.53	127.64	13302.0
2012-06-05 06:00:00	SPY	ETF	127.69	127.71	127.64	127.7	4900.0
2012-06-05 06:30:00	SPY	ETF	127.69	127.69	127.58	127.62	22990.0
2012-06-05 07:00:00	SPY	ETF	127.6	127.6	127.35	127.5	125412.0
2012-06-05 07:30:00	SPY	ETF	127.51	127.77	127.42	127.74	64622.0
2012-06-05 08:00:00	SPY	ETF	127.72	127.94	127.53	127.84	329823.0
2012-06-05 08:30:00	SPY	ETF	127.83	128.15	127.78	127.9	1377450.0
2012-06-05 09:00:00	SPY	ETF	127.88	128.1	127.75	127.84	967247.0
2012-06-05 09:30:00	SPY	ETF	127.85	128.47	127.78	128.42	15886172.0
2012-06-05 10:00:00	SPY	ETF	128.41	129.03	128.4	128.86	19857543.0
2012-06-05 10:30:00	SPY	ETF	128.8699	128.9	128.32	128.47	12773960.0
2012-06-05 11:00:00	SPY	ETF	128.48	128.8	128.37	128.61	8269636.0
2012-06-05 11:30:00	SPY	ETF	128.61	128.78	128.22	128.26	11003853.0
2012-06-05 12:00:00	SPY	ETF	128.26	128.57	128.24	128.52	7801956.0
2012-06-05 12:30:00	SPY	ETF	128.52	128.89	128.49	128.62	11449553.0
2012-06-05 13:00:00	SPY	ETF	128.62	128.68	128.43	128.64	4372233.0
2012-06-05 13:30:00	SPY	ETF	128.64	128.99	128.57	128.86	7191946.0
2012-06-05 14:00:00	SPY	ETF	128.86	129.06	128.77	129.0	11096160.0
2012-06-05 14:30:00	SPY	ETF	129.0	129.06	128.79	128.979	5535005.0
2012-06-05 15:00:00	SPY	ETF	128.98	129.15	128.82	128.96	9016073.0
2012-06-05 15:30:00	SPY	ETF	128.955	129.26	128.92	129.019	18790699.0
2012-06-05 16:00:00	SPY	ETF	129.01	129.19	128.8	129.13	11357120.0
2012-06-05 16:30:00	SPY	ETF	129.12	129.15	129.07	129.07	1457157.0
2012-06-05 17:00:00	SPY	ETF	129.1	129.11	128.96	129.08	74639.0
2012-06-05 17:30:00	SPY	ETF	129.08	129.1	129.05	129.07	12750.0
2012-06-05 18:00:00	SPY	ETF	129.09	129.09	128.98	128.99	35450.0
2012-06-05 18:30:00	SPY	ETF	129.0	129.13	128.93	129.13	51454.0
2012-06-05 19:00:00	SPY	ETF	129.14	129.24	129.12	129.24	73926.0
2012-06-05 19:30:00	SPY	ETF	129.23	129.6	129.23	129.4	301459.0
2012-06-05 04:00:00	QQQ	ETF	60.9	60.91	60.89	60.89	2800.0
2012-06-05 04:30:00	QQQ	ETF	60.62	60.62	60.62	60.62	200.0
2012-06-05 05:00:00	QQQ	ETF	60.68	60.68	60.68	60.68	1500.0
2012-06-05 06:00:00	QQQ	ETF	60.57	60.6	60.57	60.58	5100.0
2012-06-05 06:30:00	QQQ	ETF	60.6	60.6	60.59	60.59	1500.0
2012-06-05 07:00:00	QQQ	ETF	60.54	60.56	60.46	60.5	18500.0
2012-06-05 07:30:00	QQQ	ETF	60.54	60.64	60.5	60.63	11770.0
2012-06-05 08:00:00	QQQ	ETF	60.62	60.75	60.55	60.66	51305.0
2012-06-05 08:30:00	QQQ	ETF	60.68	60.88	60.65	60.72	166647.0
2012-06-05 09:00:00	QQQ	ETF	60.72	60.84	60.62	60.65	213778.0
2012-06-05 09:30:00	QQQ	ETF	60.65	61.0	60.63	60.9	4194468.0
2012-06-05 10:00:00	QQQ	ETF	60.9	61.18	60.89	61.089	4395370.0
2012-06-05 10:30:00	QQQ	ETF	61.09	61.11	60.74	60.82	4827161.0
2012-06-05 11:00:00	QQQ	ETF	60.8177	61.035	60.76	60.9191	1919841.0
2012-06-05 11:30:00	QQQ	ETF	60.92	61.0	60.66	60.67	3111729.0
2012-06-05 12:00:00	QQQ	ETF	60.67	60.83	60.65	60.75	1680403.0
2012-06-05 12:30:00	QQQ	ETF	60.75	60.94	60.74	60.84	2304364.0
2012-06-05 13:00:00	QQQ	ETF	60.83	60.86	60.72	60.859	1150818.0

> showing 50 of 9,470 rows — these rows as CSV

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