PREVIEW / etf_30min / 2016-05-11

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-05-11.parquet
  size:    392 KB
  rows:    13,256

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-11 04:00:00	SPY	ETF	207.77	207.77	207.46	207.6	21493.0
2016-05-11 04:30:00	SPY	ETF	207.57	207.83	207.55	207.83	4430.0
2016-05-11 05:00:00	SPY	ETF	207.82	207.83	207.72	207.72	1908.0
2016-05-11 05:30:00	SPY	ETF	207.77	207.87	207.71	207.85	9464.0
2016-05-11 06:00:00	SPY	ETF	207.85	207.85	207.68	207.75	6068.0
2016-05-11 06:30:00	SPY	ETF	207.76	207.8	207.66	207.8	11918.0
2016-05-11 07:00:00	SPY	ETF	207.8	207.99	207.77	207.92	293416.0
2016-05-11 07:30:00	SPY	ETF	207.94	207.94	207.85	207.94	35557.0
2016-05-11 08:00:00	SPY	ETF	207.71	208.05	207.71	208.04	426465.0
2016-05-11 08:30:00	SPY	ETF	208.05	208.46	207.95	208.05	227591.0
2016-05-11 09:00:00	SPY	ETF	208.06	208.06	207.84	207.91	313522.0
2016-05-11 09:30:00	SPY	ETF	207.91	208.54	207.63	207.71	6889878.0
2016-05-11 10:00:00	SPY	ETF	207.7	207.915	207.56	207.91	5062667.0
2016-05-11 10:30:00	SPY	ETF	207.92	208.33	207.89	207.945	8805155.0
2016-05-11 11:00:00	SPY	ETF	207.945	207.96	207.39	207.66	5359635.0
2016-05-11 11:30:00	SPY	ETF	207.65	207.8	207.54	207.5735	3232722.0
2016-05-11 12:00:00	SPY	ETF	207.57	207.7	207.43	207.62	2035950.0
2016-05-11 12:30:00	SPY	ETF	207.625	207.77	207.48	207.54	2483573.0
2016-05-11 13:00:00	SPY	ETF	207.541	207.63	207.26	207.38	2980579.0
2016-05-11 13:30:00	SPY	ETF	207.39	207.445	207.19	207.2	4179364.0
2016-05-11 14:00:00	SPY	ETF	207.19	207.22	206.82	207.04	5918655.0
2016-05-11 14:30:00	SPY	ETF	207.04	207.07	206.67	206.749	3548858.0
2016-05-11 15:00:00	SPY	ETF	206.75	206.96	206.69	206.84	6267720.0
2016-05-11 15:30:00	SPY	ETF	206.85	206.9601	206.5	206.56	16204634.0
2016-05-11 16:00:00	SPY	ETF	206.56	206.57	206.27	206.32	4150577.0
2016-05-11 16:30:00	SPY	ETF	206.3	208.5005	206.3	206.44	1075664.0
2016-05-11 17:00:00	SPY	ETF	206.44	208.5005	206.35	208.5005	568062.0
2016-05-11 17:30:00	SPY	ETF	206.42	206.5	206.4	206.42	27378.0
2016-05-11 18:00:00	SPY	ETF	206.39	206.54	206.35	206.51	45785.0
2016-05-11 18:30:00	SPY	ETF	206.52	206.54	206.48	206.5	12418.0
2016-05-11 19:00:00	SPY	ETF	206.52	206.58	206.51	206.56	36244.0
2016-05-11 19:30:00	SPY	ETF	206.56	206.57	206.48	206.49	40473.0
2016-05-11 04:00:00	QQQ	ETF	106.91	106.91	106.91	106.91	167.0
2016-05-11 04:30:00	QQQ	ETF	106.92	106.92	106.92	106.92	400.0
2016-05-11 05:00:00	QQQ	ETF	106.95	106.95	106.95	106.95	1000.0
2016-05-11 05:30:00	QQQ	ETF	106.98	106.98	106.95	106.96	10948.0
2016-05-11 06:00:00	QQQ	ETF	106.98	106.98	106.98	106.98	1000.0
2016-05-11 07:00:00	QQQ	ETF	107.04	107.06	107.01	107.05	9996.0
2016-05-11 07:30:00	QQQ	ETF	107.05	107.05	107.0	107.0	6599.0
2016-05-11 08:00:00	QQQ	ETF	107.07	107.18	107.04	107.16	98286.0
2016-05-11 08:30:00	QQQ	ETF	107.18	107.18	107.13	107.18	26978.0
2016-05-11 09:00:00	QQQ	ETF	107.16	107.16	107.07	107.14	76204.0
2016-05-11 09:30:00	QQQ	ETF	107.16	107.23	106.9799	107.19	1942512.0
2016-05-11 10:00:00	QQQ	ETF	107.19	107.335	107.11	107.3	1381482.0
2016-05-11 10:30:00	QQQ	ETF	107.31	107.49	107.12	107.13	2101989.0
2016-05-11 11:00:00	QQQ	ETF	107.13	107.14	106.83	106.98	1480890.0
2016-05-11 11:30:00	QQQ	ETF	106.98	107.1	106.92	106.951	1140423.0
2016-05-11 12:00:00	QQQ	ETF	106.95	107.105	106.8702	107.03	706927.0
2016-05-11 12:30:00	QQQ	ETF	107.02	107.095	106.9383	106.9895	383382.0
2016-05-11 13:00:00	QQQ	ETF	106.99	107.01	106.75	106.8333	614180.0

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

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