PREVIEW / etf_30min / 2016-05-24

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-05-24.parquet
  size:    396 KB
  rows:    13,447

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-05-24 04:00:00	SPY	ETF	205.16	205.56	205.16	205.39	5976.0
2016-05-24 04:30:00	SPY	ETF	205.46	205.6	205.45	205.51	2668.0
2016-05-24 05:00:00	SPY	ETF	205.43	205.71	205.43	205.66	9891.0
2016-05-24 05:30:00	SPY	ETF	205.64	205.82	205.64	205.73	9913.0
2016-05-24 06:00:00	SPY	ETF	205.76	205.76	205.64	205.67	51270.0
2016-05-24 06:30:00	SPY	ETF	205.69	205.86	205.68	205.72	31535.0
2016-05-24 07:00:00	SPY	ETF	205.75	205.85	205.75	205.79	31084.0
2016-05-24 07:30:00	SPY	ETF	205.77	205.95	205.77	205.88	100598.0
2016-05-24 08:00:00	SPY	ETF	205.88	206.29	205.235	206.25	750640.0
2016-05-24 08:30:00	SPY	ETF	206.28	206.35	206.16	206.2	189410.0
2016-05-24 09:00:00	SPY	ETF	206.21	206.23	206.12	206.15	398019.0
2016-05-24 09:30:00	SPY	ETF	206.17	207.09	206.14	206.87	10517303.0
2016-05-24 10:00:00	SPY	ETF	206.88	207.43	206.8708	207.38	10662176.0
2016-05-24 10:30:00	SPY	ETF	207.38	207.71	207.36	207.58	7858868.0
2016-05-24 11:00:00	SPY	ETF	207.585	207.75	207.51	207.62	5636149.0
2016-05-24 11:30:00	SPY	ETF	207.625	207.835	207.49	207.8	5730539.0
2016-05-24 12:00:00	SPY	ETF	207.7999	207.83	207.66	207.67	2115327.0
2016-05-24 12:30:00	SPY	ETF	207.67	207.89	207.61	207.89	3251063.0
2016-05-24 13:00:00	SPY	ETF	207.885	207.96	207.75	207.78	2546107.0
2016-05-24 13:30:00	SPY	ETF	207.78	207.83	207.57	207.65	3183534.0
2016-05-24 14:00:00	SPY	ETF	207.66	207.79	207.55	207.67	3274272.0
2016-05-24 14:30:00	SPY	ETF	207.67	207.92	207.61	207.7929	3778987.0
2016-05-24 15:00:00	SPY	ETF	207.79	208.24	207.78	208.11	7665721.0
2016-05-24 15:30:00	SPY	ETF	208.11	208.13	207.83	207.85	12357625.0
2016-05-24 16:00:00	SPY	ETF	207.85	208.09	207.82	208.09	4720764.0
2016-05-24 16:30:00	SPY	ETF	208.09	208.12	207.87	208.04	818760.0
2016-05-24 17:00:00	SPY	ETF	208.03	208.05	208.0	208.01	78111.0
2016-05-24 17:30:00	SPY	ETF	208.02	208.06	207.87	208.05	145721.0
2016-05-24 18:00:00	SPY	ETF	208.05	208.05	207.9	208.0	49558.0
2016-05-24 18:30:00	SPY	ETF	207.99	208.15	207.99	208.14	40302.0
2016-05-24 19:00:00	SPY	ETF	208.15	208.44	208.15	208.4	69153.0
2016-05-24 19:30:00	SPY	ETF	208.41	208.41	208.31	208.36	144627.0
2016-05-24 04:00:00	QQQ	ETF	106.41	106.41	106.41	106.41	133.0
2016-05-24 05:00:00	QQQ	ETF	106.49	106.57	106.49	106.57	1400.0
2016-05-24 05:30:00	QQQ	ETF	106.66	106.66	106.66	106.66	2500.0
2016-05-24 07:00:00	QQQ	ETF	106.69	106.69	106.63	106.66	5764.0
2016-05-24 07:30:00	QQQ	ETF	106.69	106.75	106.68	106.73	6022.0
2016-05-24 08:00:00	QQQ	ETF	106.68	106.94	106.68	106.92	72871.0
2016-05-24 08:30:00	QQQ	ETF	106.92	106.98	106.92	106.95	25981.0
2016-05-24 09:00:00	QQQ	ETF	106.93	106.95	106.87	106.89	62576.0
2016-05-24 09:30:00	QQQ	ETF	106.92	107.565	106.885	107.44	4043970.0
2016-05-24 10:00:00	QQQ	ETF	107.45	107.893	107.45	107.88	2951804.0
2016-05-24 10:30:00	QQQ	ETF	107.88	108.09	107.88	108.05	1934524.0
2016-05-24 11:00:00	QQQ	ETF	108.055	108.21	108.01	108.14	1713606.0
2016-05-24 11:30:00	QQQ	ETF	108.15	108.29	108.08	108.28	1078220.0
2016-05-24 12:00:00	QQQ	ETF	108.28	108.29	108.155	108.18	522706.0
2016-05-24 12:30:00	QQQ	ETF	108.19	108.32	108.17	108.32	709574.0
2016-05-24 13:00:00	QQQ	ETF	108.32	108.38	108.27	108.31	710219.0
2016-05-24 13:30:00	QQQ	ETF	108.32	108.37	108.22	108.315	792837.0
2016-05-24 14:00:00	QQQ	ETF	108.31	108.45	108.27	108.344	1116886.0

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

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