PREVIEW / etf_30min / 2015-06-26

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-06-26.parquet
  size:    374 KB
  rows:    12,681

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
2015-06-26 04:00:00	SPY	ETF	209.71	209.84	209.71	209.84	300.0
2015-06-26 04:30:00	SPY	ETF	209.89	209.9	209.89	209.9	800.0
2015-06-26 05:00:00	SPY	ETF	209.88	209.97	209.88	209.97	4505.0
2015-06-26 05:30:00	SPY	ETF	209.85	209.85	209.73	209.79	6171.0
2015-06-26 06:00:00	SPY	ETF	209.8	209.87	209.77	209.87	2502.0
2015-06-26 06:30:00	SPY	ETF	209.89	210.24	209.86	210.24	19155.0
2015-06-26 07:00:00	SPY	ETF	210.2	210.37	210.08	210.33	56313.0
2015-06-26 07:30:00	SPY	ETF	210.3	210.43	210.26	210.36	171093.0
2015-06-26 08:00:00	SPY	ETF	210.34	210.36	209.75	210.09	345717.0
2015-06-26 08:30:00	SPY	ETF	210.07	210.33	210.05	210.3	603512.0
2015-06-26 09:00:00	SPY	ETF	210.29	210.36	210.17	210.28	587195.0
2015-06-26 09:30:00	SPY	ETF	210.29	210.47	209.64	210.36	10102496.0
2015-06-26 10:00:00	SPY	ETF	210.37	210.58	209.98	210.3699	8508062.0
2015-06-26 10:30:00	SPY	ETF	210.3699	210.41	209.825	209.87	5379750.0
2015-06-26 11:00:00	SPY	ETF	209.87	210.32	209.83	210.22	3946142.0
2015-06-26 11:30:00	SPY	ETF	210.23	210.33	209.91	209.96	4056765.0
2015-06-26 12:00:00	SPY	ETF	209.96	210.17	209.91	210.09	2583650.0
2015-06-26 12:30:00	SPY	ETF	210.09	210.09	209.4	209.415	5486302.0
2015-06-26 13:00:00	SPY	ETF	209.42	209.61	209.16	209.4601	7890572.0
2015-06-26 13:30:00	SPY	ETF	209.465	209.825	209.37	209.64	5203162.0
2015-06-26 14:00:00	SPY	ETF	209.64	209.71	209.44	209.61	2852682.0
2015-06-26 14:30:00	SPY	ETF	209.6	209.78	209.48	209.63	4403766.0
2015-06-26 15:00:00	SPY	ETF	209.63	210.13	209.61	210.055	7164419.0
2015-06-26 15:30:00	SPY	ETF	210.05	210.08	209.71	209.83	16928369.0
2015-06-26 16:00:00	SPY	ETF	209.83	210.5	209.78	210.06	9301376.0
2015-06-26 16:30:00	SPY	ETF	210.06	210.17	209.82	210.13	6561896.0
2015-06-26 17:00:00	SPY	ETF	210.13	210.14	210.01	210.07	411221.0
2015-06-26 17:30:00	SPY	ETF	210.073	210.13	209.8	209.86	303682.0
2015-06-26 18:00:00	SPY	ETF	209.86	209.94	209.75	209.79	120726.0
2015-06-26 18:30:00	SPY	ETF	209.86	209.86	209.66	209.68	153952.0
2015-06-26 19:00:00	SPY	ETF	209.67	209.69	209.37	209.37	180794.0
2015-06-26 19:30:00	SPY	ETF	209.37	209.53	209.26	209.35	71652.0
2015-06-26 04:00:00	QQQ	ETF	109.9	109.9	109.9	109.9	100.0
2015-06-26 05:00:00	QQQ	ETF	109.95	109.95	109.95	109.95	100.0
2015-06-26 06:30:00	QQQ	ETF	110.05	110.05	110.05	110.05	100.0
2015-06-26 07:00:00	QQQ	ETF	109.99	110.22	109.99	110.16	15800.0
2015-06-26 07:30:00	QQQ	ETF	110.21	110.21	110.14	110.15	11480.0
2015-06-26 08:00:00	QQQ	ETF	110.16	110.16	109.9	109.93	15250.0
2015-06-26 08:30:00	QQQ	ETF	109.92	110.01	109.87	110.0	60656.0
2015-06-26 09:00:00	QQQ	ETF	109.98	110.01	109.89	109.97	165259.0
2015-06-26 09:30:00	QQQ	ETF	109.98	110.11	109.56	110.07	4978139.0
2015-06-26 10:00:00	QQQ	ETF	110.08	110.23	109.7399	109.92	2305640.0
2015-06-26 10:30:00	QQQ	ETF	109.92	109.93	109.47	109.48	1695342.0
2015-06-26 11:00:00	QQQ	ETF	109.48	109.78	109.45	109.67	1199402.0
2015-06-26 11:30:00	QQQ	ETF	109.67	109.73	109.47	109.51	935836.0
2015-06-26 12:00:00	QQQ	ETF	109.505	109.595	109.46	109.53	554739.0
2015-06-26 12:30:00	QQQ	ETF	109.525	109.525	108.9488	108.97	2328666.0
2015-06-26 13:00:00	QQQ	ETF	108.96	109.0988	108.86	109.06	1754542.0
2015-06-26 13:30:00	QQQ	ETF	109.06	109.27	108.99	109.15	1286659.0
2015-06-26 14:00:00	QQQ	ETF	109.15	109.16	108.96	109.1	1095975.0

> showing 50 of 12,681 rows — these rows as CSV

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