PREVIEW / etf_30min / 2017-12-04

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-12-04.parquet
  size:    472 KB
  rows:    16,387

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
2017-12-04 04:00:00	SPY	ETF	265.9	266.15	265.9	266.05	12892.0
2017-12-04 04:30:00	SPY	ETF	266.06	266.06	265.87	265.87	700.0
2017-12-04 05:00:00	SPY	ETF	265.87	266.1	265.87	266.07	23789.0
2017-12-04 05:30:00	SPY	ETF	266.12	266.27	266.06	266.23	13205.0
2017-12-04 06:00:00	SPY	ETF	266.23	266.32	266.18	266.32	18401.0
2017-12-04 06:30:00	SPY	ETF	266.3	266.37	266.3	266.34	69372.0
2017-12-04 07:00:00	SPY	ETF	266.31	266.35	266.23	266.35	194026.0
2017-12-04 07:30:00	SPY	ETF	266.35	266.38	266.18	266.18	313109.0
2017-12-04 08:00:00	SPY	ETF	264.46	266.36	264.46	266.04	400081.0
2017-12-04 08:30:00	SPY	ETF	266.04	266.1	265.94	266.09	253862.0
2017-12-04 09:00:00	SPY	ETF	266.07	266.34	266.03	266.31	592754.0
2017-12-04 09:30:00	SPY	ETF	266.31	266.8	266.17	266.42	12200932.0
2017-12-04 10:00:00	SPY	ETF	266.42	266.5	266.04	266.39	9962333.0
2017-12-04 10:30:00	SPY	ETF	266.39	266.445	265.36	265.65	9369748.0
2017-12-04 11:00:00	SPY	ETF	265.64	265.94	265.37	265.77	4086797.0
2017-12-04 11:30:00	SPY	ETF	265.779	266.0	265.6	265.8	3553635.0
2017-12-04 12:00:00	SPY	ETF	265.8	266.04	265.56	265.69	3834094.0
2017-12-04 12:30:00	SPY	ETF	265.68	265.87	265.465	265.81	2617048.0
2017-12-04 13:00:00	SPY	ETF	265.81	266.0	265.75	265.825	2318422.0
2017-12-04 13:30:00	SPY	ETF	265.82	266.01	265.8	265.939	2621639.0
2017-12-04 14:00:00	SPY	ETF	265.94	265.95	265.14	265.22	4791836.0
2017-12-04 14:30:00	SPY	ETF	265.225	265.23	264.85	265.03	5218195.0
2017-12-04 15:00:00	SPY	ETF	265.03	265.06	264.76	264.81	5474489.0
2017-12-04 15:30:00	SPY	ETF	264.81	264.94	264.12	264.13	13105803.0
2017-12-04 16:00:00	SPY	ETF	264.12	264.21	263.99	264.07	9633641.0
2017-12-04 16:30:00	SPY	ETF	264.05	264.14	263.7	263.94	593343.0
2017-12-04 17:00:00	SPY	ETF	263.92	264.01	263.92	263.96	44688.0
2017-12-04 17:30:00	SPY	ETF	266.1945	266.1945	263.92	263.94	203725.0
2017-12-04 18:00:00	SPY	ETF	263.94	264.1	263.9	263.93	40972.0
2017-12-04 18:30:00	SPY	ETF	264.0	264.15	264.0	264.12	39576.0
2017-12-04 19:00:00	SPY	ETF	264.09	264.27	264.0	264.24	37134.0
2017-12-04 19:30:00	SPY	ETF	264.2	264.2	264.08	264.08	6695.0
2017-12-04 04:00:00	QQQ	ETF	155.3	155.5	155.2	155.22	2200.0
2017-12-04 04:30:00	QQQ	ETF	155.35	155.35	155.13	155.13	1232.0
2017-12-04 05:00:00	QQQ	ETF	155.13	155.2	155.12	155.2	19700.0
2017-12-04 05:30:00	QQQ	ETF	155.25	155.4	155.25	155.4	2716.0
2017-12-04 06:00:00	QQQ	ETF	155.35	155.44	155.35	155.42	14498.0
2017-12-04 06:30:00	QQQ	ETF	155.44	155.48	155.42	155.43	18935.0
2017-12-04 07:00:00	QQQ	ETF	155.4	155.47	155.32	155.47	89875.0
2017-12-04 07:30:00	QQQ	ETF	155.49	155.52	155.33	155.33	121304.0
2017-12-04 08:00:00	QQQ	ETF	155.35	155.52	155.24	155.35	137518.0
2017-12-04 08:30:00	QQQ	ETF	155.35	155.45	155.34	155.36	118355.0
2017-12-04 09:00:00	QQQ	ETF	155.45	155.51	155.41	155.48	229962.0
2017-12-04 09:30:00	QQQ	ETF	155.47	155.625	154.78	154.85	6732527.0
2017-12-04 10:00:00	QQQ	ETF	154.86	154.86	153.72	154.29	6438232.0
2017-12-04 10:30:00	QQQ	ETF	154.3008	154.32	152.99	153.25	4436606.0
2017-12-04 11:00:00	QQQ	ETF	153.245	153.79	152.98	153.64	3961382.0
2017-12-04 11:30:00	QQQ	ETF	153.6553	153.75	153.29	153.59	2181012.0
2017-12-04 12:00:00	QQQ	ETF	153.58	153.93	153.45	153.6361	1835690.0
2017-12-04 12:30:00	QQQ	ETF	153.63	154.06	153.51	154.02	1526136.0

> showing 50 of 16,387 rows — these rows as CSV

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