PREVIEW / etf_30min / 2016-04-06

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-04-06.parquet
  size:    390 KB
  rows:    13,111

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
2016-04-06 04:00:00	SPY	ETF	204.93	205.1	204.56	204.68	18558.0
2016-04-06 04:30:00	SPY	ETF	204.78	205.05	204.78	205.05	17400.0
2016-04-06 05:00:00	SPY	ETF	205.09	205.13	205.03	205.06	10284.0
2016-04-06 05:30:00	SPY	ETF	205.07	205.14	204.99	205.08	8339.0
2016-04-06 06:00:00	SPY	ETF	205.0	205.0	204.76	204.78	22285.0
2016-04-06 06:30:00	SPY	ETF	204.76	204.86	204.62	204.68	110347.0
2016-04-06 07:00:00	SPY	ETF	204.69	204.79	204.64	204.67	118259.0
2016-04-06 07:30:00	SPY	ETF	204.66	204.9	204.62	204.83	44370.0
2016-04-06 08:00:00	SPY	ETF	204.9729	205.0	204.54	204.63	327024.0
2016-04-06 08:30:00	SPY	ETF	204.61	204.67	204.38	204.46	316934.0
2016-04-06 09:00:00	SPY	ETF	204.44	204.53	204.27	204.28	478765.0
2016-04-06 09:30:00	SPY	ETF	204.29	204.64	203.98	204.345	8970877.0
2016-04-06 10:00:00	SPY	ETF	204.35	204.61	204.1	204.24	6318980.0
2016-04-06 10:30:00	SPY	ETF	204.25	205.18	204.03	205.17	9121545.0
2016-04-06 11:00:00	SPY	ETF	205.18	205.46	205.12	205.44	5473057.0
2016-04-06 11:30:00	SPY	ETF	205.44	205.67	205.36	205.6	4990075.0
2016-04-06 12:00:00	SPY	ETF	205.6	205.66	205.367	205.53	3190920.0
2016-04-06 12:30:00	SPY	ETF	205.52	205.65	205.47	205.4969	2403345.0
2016-04-06 13:00:00	SPY	ETF	205.495	205.8999	205.495	205.7308	3595552.0
2016-04-06 13:30:00	SPY	ETF	205.73	205.91	205.59	205.65	2688198.0
2016-04-06 14:00:00	SPY	ETF	205.66	205.68	205.21	205.37	8032674.0
2016-04-06 14:30:00	SPY	ETF	205.37	205.7	205.03	205.63	5058155.0
2016-04-06 15:00:00	SPY	ETF	205.63	206.22	205.54	206.08	9180131.0
2016-04-06 15:30:00	SPY	ETF	206.08	206.49	206.0	206.43	13005730.0
2016-04-06 16:00:00	SPY	ETF	206.42	206.49	204.2461	206.47	5521821.0
2016-04-06 16:30:00	SPY	ETF	206.47	206.5	206.37	206.37	232767.0
2016-04-06 17:00:00	SPY	ETF	206.37	206.38	206.33	206.38	148756.0
2016-04-06 17:30:00	SPY	ETF	206.4	206.42	206.32	206.4	129687.0
2016-04-06 18:00:00	SPY	ETF	206.33	206.46	206.26	206.29	62464.0
2016-04-06 18:30:00	SPY	ETF	206.3	206.35	206.26	206.28	33512.0
2016-04-06 19:00:00	SPY	ETF	206.26	206.31	206.25	206.31	12055.0
2016-04-06 19:30:00	SPY	ETF	206.3	206.34	206.24	206.3	52631.0
2016-04-06 04:30:00	QQQ	ETF	109.23	109.23	109.23	109.23	200.0
2016-04-06 05:30:00	QQQ	ETF	109.42	109.42	109.41	109.41	10000.0
2016-04-06 06:00:00	QQQ	ETF	109.39	109.39	109.39	109.39	600.0
2016-04-06 07:00:00	QQQ	ETF	109.24	109.3	109.2	109.2	5000.0
2016-04-06 07:30:00	QQQ	ETF	109.2	109.29	109.17	109.27	20202.0
2016-04-06 08:00:00	QQQ	ETF	109.26	109.29	109.17	109.21	59774.0
2016-04-06 08:30:00	QQQ	ETF	109.2	109.22	109.07	109.11	60271.0
2016-04-06 09:00:00	QQQ	ETF	109.12	109.15	109.01	109.01	54189.0
2016-04-06 09:30:00	QQQ	ETF	109.0	109.39	108.99	109.31	2107914.0
2016-04-06 10:00:00	QQQ	ETF	109.31	109.47	109.06	109.125	1310790.0
2016-04-06 10:30:00	QQQ	ETF	109.13	109.66	109.02	109.66	2169650.0
2016-04-06 11:00:00	QQQ	ETF	109.655	109.92	109.61	109.91	1536384.0
2016-04-06 11:30:00	QQQ	ETF	109.92	110.0199	109.84	109.96	1366570.0
2016-04-06 12:00:00	QQQ	ETF	109.96	110.0	109.8	109.97	910489.0
2016-04-06 12:30:00	QQQ	ETF	109.97	110.065	109.92	109.98	809776.0
2016-04-06 13:00:00	QQQ	ETF	109.98	110.21	109.98	110.1282	1000847.0
2016-04-06 13:30:00	QQQ	ETF	110.1289	110.26	110.0945	110.13	904341.0
2016-04-06 14:00:00	QQQ	ETF	110.14	110.2	109.93	110.01	1781074.0

> showing 50 of 13,111 rows — these rows as CSV

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