PREVIEW / etf_30min / 2016-01-21

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-01-21.parquet
  size:    415 KB
  rows:    14,022

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-01-21 04:00:00	SPY	ETF	185.32	185.32	184.29	185.05	8761.0
2016-01-21 04:30:00	SPY	ETF	185.08	185.28	184.63	185.1	5860.0
2016-01-21 05:00:00	SPY	ETF	185.14	185.63	185.14	185.34	10752.0
2016-01-21 05:30:00	SPY	ETF	185.57	185.75	185.07	185.59	6282.0
2016-01-21 06:00:00	SPY	ETF	185.4	185.62	184.72	185.11	30786.0
2016-01-21 06:30:00	SPY	ETF	185.15	185.32	184.97	185.19	80723.0
2016-01-21 07:00:00	SPY	ETF	185.19	185.34	184.84	185.27	210751.0
2016-01-21 07:30:00	SPY	ETF	185.24	185.99	185.0	185.75	474910.0
2016-01-21 08:00:00	SPY	ETF	185.75	186.87	184.85	186.44	913829.0
2016-01-21 08:30:00	SPY	ETF	186.45	187.97	186.35	186.74	3065028.0
2016-01-21 09:00:00	SPY	ETF	186.73	187.16	186.0	186.22	1939354.0
2016-01-21 09:30:00	SPY	ETF	186.21	186.74	184.64	185.11	22318439.0
2016-01-21 10:00:00	SPY	ETF	185.105	187.37	185.06	187.07	17301116.0
2016-01-21 10:30:00	SPY	ETF	187.07	187.91	186.6389	186.88	14311123.0
2016-01-21 11:00:00	SPY	ETF	186.89	188.02	186.46	186.99	13841303.0
2016-01-21 11:30:00	SPY	ETF	187.0	188.27	186.99	188.16	9181229.0
2016-01-21 12:00:00	SPY	ETF	188.16	188.87	188.03	188.47	12259775.0
2016-01-21 12:30:00	SPY	ETF	188.49	188.63	187.89	188.12	6020256.0
2016-01-21 13:00:00	SPY	ETF	188.1101	188.62	187.21	187.22	8731703.0
2016-01-21 13:30:00	SPY	ETF	187.2101	187.71	186.79	187.27	15186575.0
2016-01-21 14:00:00	SPY	ETF	187.3	187.47	185.77	186.4001	13943518.0
2016-01-21 14:30:00	SPY	ETF	186.4	187.5499	186.38	187.36	12732190.0
2016-01-21 15:00:00	SPY	ETF	187.365	187.3972	186.305	186.829	10727254.0
2016-01-21 15:30:00	SPY	ETF	186.83	187.68	186.65	186.68	16089798.0
2016-01-21 16:00:00	SPY	ETF	186.68	187.0	186.44	186.78	8286372.0
2016-01-21 16:30:00	SPY	ETF	186.76	186.76	186.39	186.66	3500477.0
2016-01-21 17:00:00	SPY	ETF	186.64	186.67	186.45	186.46	180488.0
2016-01-21 17:30:00	SPY	ETF	186.46	186.52	186.38	186.38	344145.0
2016-01-21 18:00:00	SPY	ETF	186.41	186.75	186.17	186.39	216226.0
2016-01-21 18:30:00	SPY	ETF	186.35	187.0	186.35	186.92	158405.0
2016-01-21 19:00:00	SPY	ETF	186.94	187.05	186.42	186.98	159959.0
2016-01-21 19:30:00	SPY	ETF	186.99	187.44	186.8	186.97	127713.0
2016-01-21 04:00:00	QQQ	ETF	100.2	100.2	99.81	100.04	9470.0
2016-01-21 04:30:00	QQQ	ETF	100.41	100.41	100.0	100.02	1400.0
2016-01-21 05:00:00	QQQ	ETF	100.31	100.53	100.31	100.53	1000.0
2016-01-21 05:30:00	QQQ	ETF	100.42	100.42	100.21	100.42	2425.0
2016-01-21 06:00:00	QQQ	ETF	100.56	100.56	100.21	100.22	8478.0
2016-01-21 06:30:00	QQQ	ETF	100.41	100.45	100.31	100.44	4750.0
2016-01-21 07:00:00	QQQ	ETF	100.42	100.53	100.25	100.47	28903.0
2016-01-21 07:30:00	QQQ	ETF	100.42	100.91	100.39	100.78	40932.0
2016-01-21 08:00:00	QQQ	ETF	100.43	101.35	100.39	101.14	230825.0
2016-01-21 08:30:00	QQQ	ETF	101.19	102.06	101.12	101.4	658555.0
2016-01-21 09:00:00	QQQ	ETF	101.45	101.54	100.96	101.18	326508.0
2016-01-21 09:30:00	QQQ	ETF	101.19	101.2	99.82	100.095	8046416.0
2016-01-21 10:00:00	QQQ	ETF	100.1	101.64	100.07	101.45	6085603.0
2016-01-21 10:30:00	QQQ	ETF	101.45	101.87	101.16	101.29	4655099.0
2016-01-21 11:00:00	QQQ	ETF	101.3	101.93	101.06	101.32	4663137.0
2016-01-21 11:30:00	QQQ	ETF	101.32	102.01	101.254	101.95	2911845.0
2016-01-21 12:00:00	QQQ	ETF	101.96	102.349	101.96	102.22	2723797.0
2016-01-21 12:30:00	QQQ	ETF	102.215	102.25	101.82	101.9	1706167.0

> showing 50 of 14,022 rows — these rows as CSV

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