PREVIEW / etf_30min / 2016-06-30

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-06-30.parquet
  size:    418 KB
  rows:    14,083

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-06-30 04:00:00	SPY	ETF	207.28	207.5	207.19	207.19	10933.0
2016-06-30 04:30:00	SPY	ETF	207.05	207.26	207.04	207.26	12215.0
2016-06-30 05:00:00	SPY	ETF	207.33	207.33	207.12	207.21	10085.0
2016-06-30 05:30:00	SPY	ETF	207.29	207.74	207.29	207.68	15938.0
2016-06-30 06:00:00	SPY	ETF	207.7	207.72	207.53	207.62	44134.0
2016-06-30 06:30:00	SPY	ETF	207.61	207.82	207.5	207.51	153915.0
2016-06-30 07:00:00	SPY	ETF	207.56	207.56	207.3	207.41	128067.0
2016-06-30 07:30:00	SPY	ETF	207.39	207.41	206.95	206.99	464347.0
2016-06-30 08:00:00	SPY	ETF	207.0	207.53	206.74	206.98	746425.0
2016-06-30 08:30:00	SPY	ETF	206.98	207.26	206.98	207.22	415558.0
2016-06-30 09:00:00	SPY	ETF	207.24	207.28	206.71	207.21	677314.0
2016-06-30 09:30:00	SPY	ETF	207.21	207.34	206.56	206.67	12048005.0
2016-06-30 10:00:00	SPY	ETF	206.675	207.06	206.56	206.75	7132208.0
2016-06-30 10:30:00	SPY	ETF	206.75	207.67	206.73	207.65	8691422.0
2016-06-30 11:00:00	SPY	ETF	207.65	208.0	207.48	207.87	9691975.0
2016-06-30 11:30:00	SPY	ETF	207.87	208.21	207.71	208.03	6706076.0
2016-06-30 12:00:00	SPY	ETF	208.03	208.8	207.98	208.69	10291479.0
2016-06-30 12:30:00	SPY	ETF	208.7	208.92	208.52	208.8499	9230535.0
2016-06-30 13:00:00	SPY	ETF	208.85	208.96	208.54	208.665	8190456.0
2016-06-30 13:30:00	SPY	ETF	208.67	208.83	208.55	208.79	5164614.0
2016-06-30 14:00:00	SPY	ETF	208.79	209.3	208.78	208.89	11243507.0
2016-06-30 14:30:00	SPY	ETF	208.89	209.28	208.735	209.2	8368565.0
2016-06-30 15:00:00	SPY	ETF	209.2	209.27	208.8	209.2	10739410.0
2016-06-30 15:30:00	SPY	ETF	209.21	209.54	208.82	209.5	26977667.0
2016-06-30 16:00:00	SPY	ETF	209.5	209.57	209.03	209.3	17352267.0
2016-06-30 16:30:00	SPY	ETF	209.3	209.53	209.08	209.1	1695291.0
2016-06-30 17:00:00	SPY	ETF	209.1	209.475	209.1	209.19	1601507.0
2016-06-30 17:30:00	SPY	ETF	209.2	209.22	209.11	209.13	291234.0
2016-06-30 18:00:00	SPY	ETF	209.15	209.475	209.01	209.14	1186336.0
2016-06-30 18:30:00	SPY	ETF	209.18	209.19	209.02	209.07	49764.0
2016-06-30 19:00:00	SPY	ETF	209.03	209.1	208.96	209.03	61928.0
2016-06-30 19:30:00	SPY	ETF	209.05	209.07	208.95	209.03	73765.0
2016-06-30 04:00:00	QQQ	ETF	106.5	106.65	106.5	106.51	2482.0
2016-06-30 04:30:00	QQQ	ETF	106.51	106.51	106.51	106.51	500.0
2016-06-30 05:00:00	QQQ	ETF	106.55	106.55	106.55	106.55	1600.0
2016-06-30 05:30:00	QQQ	ETF	106.65	106.65	106.65	106.65	500.0
2016-06-30 06:00:00	QQQ	ETF	106.7	106.7	106.7	106.7	3700.0
2016-06-30 06:30:00	QQQ	ETF	106.68	106.74	106.62	106.62	4706.0
2016-06-30 07:00:00	QQQ	ETF	106.59	106.66	106.54	106.56	25900.0
2016-06-30 07:30:00	QQQ	ETF	106.57	106.58	106.38	106.38	99931.0
2016-06-30 08:00:00	QQQ	ETF	106.36	106.36	106.19	106.3	137594.0
2016-06-30 08:30:00	QQQ	ETF	106.3	106.48	106.3	106.46	115617.0
2016-06-30 09:00:00	QQQ	ETF	106.45	106.54	106.43	106.52	206551.0
2016-06-30 09:30:00	QQQ	ETF	106.52	106.66	106.18	106.25	3970093.0
2016-06-30 10:00:00	QQQ	ETF	106.25	106.43	106.13	106.2	2268548.0
2016-06-30 10:30:00	QQQ	ETF	106.2	106.73	106.18	106.72	2479812.0
2016-06-30 11:00:00	QQQ	ETF	106.72	107.0	106.61	106.94	2687244.0
2016-06-30 11:30:00	QQQ	ETF	106.93	107.14	106.85	106.99	2079005.0
2016-06-30 12:00:00	QQQ	ETF	106.99	107.32	106.92	107.27	2492125.0
2016-06-30 12:30:00	QQQ	ETF	107.27	107.335	107.13	107.28	1621813.0

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

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