PREVIEW / etf_30min / 2017-11-30

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-11-30.parquet
  size:    470 KB
  rows:    16,121

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-11-30 04:00:00	SPY	ETF	262.9	263.19	262.9	263.19	10650.0
2017-11-30 04:30:00	SPY	ETF	263.06	263.21	263.06	263.08	9063.0
2017-11-30 05:00:00	SPY	ETF	263.1	263.18	263.06	263.18	2700.0
2017-11-30 05:30:00	SPY	ETF	263.22	263.5	263.18	263.45	28674.0
2017-11-30 06:00:00	SPY	ETF	263.48	263.63	263.45	263.58	50730.0
2017-11-30 06:30:00	SPY	ETF	263.55	263.55	263.53	263.55	3760.0
2017-11-30 07:00:00	SPY	ETF	263.54	263.54	263.34	263.44	50785.0
2017-11-30 07:30:00	SPY	ETF	263.42	263.52	263.33	263.52	158040.0
2017-11-30 08:00:00	SPY	ETF	263.4	263.57	263.4	263.55	264420.0
2017-11-30 08:30:00	SPY	ETF	263.57	263.57	263.45	263.52	297818.0
2017-11-30 09:00:00	SPY	ETF	263.55	263.87	263.52	263.74	638179.0
2017-11-30 09:30:00	SPY	ETF	263.76	264.19	263.67	263.94	10028201.0
2017-11-30 10:00:00	SPY	ETF	263.945	264.29	263.87	264.07	7403075.0
2017-11-30 10:30:00	SPY	ETF	264.08	264.41	263.77	264.37	4183749.0
2017-11-30 11:00:00	SPY	ETF	264.38	264.86	264.32	264.47	5695400.0
2017-11-30 11:30:00	SPY	ETF	264.46	264.61	264.36	264.56	4300636.0
2017-11-30 12:00:00	SPY	ETF	264.57	265.37	264.565	265.34	5550801.0
2017-11-30 12:30:00	SPY	ETF	265.335	266.05	265.325	265.56	11858557.0
2017-11-30 13:00:00	SPY	ETF	265.56	265.8782	265.3	265.45	6268814.0
2017-11-30 13:30:00	SPY	ETF	265.45	265.46	264.8	265.05	4735154.0
2017-11-30 14:00:00	SPY	ETF	265.055	265.27	264.85	265.26	5752763.0
2017-11-30 14:30:00	SPY	ETF	265.25	265.27	264.79	264.855	4948752.0
2017-11-30 15:00:00	SPY	ETF	264.855	264.86	264.35	264.82	6142609.0
2017-11-30 15:30:00	SPY	ETF	264.83	265.33	264.48	264.88	21905311.0
2017-11-30 16:00:00	SPY	ETF	264.9	265.01	264.25	264.44	21142961.0
2017-11-30 16:30:00	SPY	ETF	264.44	265.01	264.23	264.45	664093.0
2017-11-30 17:00:00	SPY	ETF	264.44	264.46	264.3	264.43	253891.0
2017-11-30 17:30:00	SPY	ETF	264.43	265.01	264.36	264.36	971149.0
2017-11-30 18:00:00	SPY	ETF	264.33	264.51	264.15	264.15	756695.0
2017-11-30 18:30:00	SPY	ETF	264.24	264.39	264.16	264.39	72732.0
2017-11-30 19:00:00	SPY	ETF	264.4	264.51	264.34	264.4	28038.0
2017-11-30 19:30:00	SPY	ETF	264.41	264.45	264.08	264.2	86324.0
2017-11-30 04:00:00	QQQ	ETF	153.82	154.01	153.79	154.01	2000.0
2017-11-30 04:30:00	QQQ	ETF	153.91	153.96	153.86	153.86	3700.0
2017-11-30 05:00:00	QQQ	ETF	153.96	153.96	153.94	153.96	700.0
2017-11-30 05:30:00	QQQ	ETF	153.99	154.08	153.99	154.08	1600.0
2017-11-30 06:00:00	QQQ	ETF	154.16	154.19	154.11	154.19	1393.0
2017-11-30 06:30:00	QQQ	ETF	154.22	154.22	154.18	154.18	3199.0
2017-11-30 07:00:00	QQQ	ETF	154.19	154.19	154.08	154.18	40802.0
2017-11-30 07:30:00	QQQ	ETF	154.17	154.25	154.06	154.23	82565.0
2017-11-30 08:00:00	QQQ	ETF	154.19	154.3	154.07	154.3	220686.0
2017-11-30 08:30:00	QQQ	ETF	154.27	154.3	154.17	154.25	223849.0
2017-11-30 09:00:00	QQQ	ETF	154.26	154.67	154.26	154.48	1255669.0
2017-11-30 09:30:00	QQQ	ETF	154.46	154.81	154.145	154.38	8582501.0
2017-11-30 10:00:00	QQQ	ETF	154.39	154.79	154.3	154.72	5525946.0
2017-11-30 10:30:00	QQQ	ETF	154.73	154.98	154.68	154.78	4209901.0
2017-11-30 11:00:00	QQQ	ETF	154.78	155.27	154.72	154.87	3903585.0
2017-11-30 11:30:00	QQQ	ETF	154.87	154.98	154.79	154.95	2412454.0
2017-11-30 12:00:00	QQQ	ETF	154.95	155.36	154.87	155.33	2181649.0
2017-11-30 12:30:00	QQQ	ETF	155.33	155.45	154.88	155.1136	4291130.0

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

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