PREVIEW / etf_30min / 2017-12-11

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-12-11.parquet
  size:    445 KB
  rows:    15,526

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-11 04:00:00	SPY	ETF	265.72	265.75	265.72	265.75	835.0
2017-12-11 04:30:00	SPY	ETF	265.63	265.63	265.55	265.55	4300.0
2017-12-11 05:00:00	SPY	ETF	265.71	265.75	265.71	265.75	900.0
2017-12-11 05:30:00	SPY	ETF	265.75	265.78	265.67	265.67	4484.0
2017-12-11 06:00:00	SPY	ETF	265.68	265.75	265.62	265.75	2118.0
2017-12-11 06:30:00	SPY	ETF	265.66	265.72	265.6	265.6	4807.0
2017-12-11 07:00:00	SPY	ETF	265.6	265.74	265.55	265.74	15720.0
2017-12-11 07:30:00	SPY	ETF	265.7	265.74	265.42	265.43	463467.0
2017-12-11 08:00:00	SPY	ETF	265.43	265.6	265.25	265.46	613026.0
2017-12-11 08:30:00	SPY	ETF	265.46	265.66	265.43	265.62	213130.0
2017-12-11 09:00:00	SPY	ETF	265.56	265.66	265.51	265.56	123933.0
2017-12-11 09:30:00	SPY	ETF	265.58	265.97	265.49	265.965	4486819.0
2017-12-11 10:00:00	SPY	ETF	265.97	266.09	265.6799	265.71	7332774.0
2017-12-11 10:30:00	SPY	ETF	265.7189	265.96	265.67	265.71	6031938.0
2017-12-11 11:00:00	SPY	ETF	265.71	265.9375	265.6	265.8901	3094571.0
2017-12-11 11:30:00	SPY	ETF	265.89	265.99	265.82	265.87	1714160.0
2017-12-11 12:00:00	SPY	ETF	265.87	266.05	265.86	266.04	4918652.0
2017-12-11 12:30:00	SPY	ETF	266.04	266.18	266.02	266.16	2602247.0
2017-12-11 13:00:00	SPY	ETF	266.16	266.29	266.08	266.09	3178875.0
2017-12-11 13:30:00	SPY	ETF	266.09	266.19	266.02	266.155	1587094.0
2017-12-11 14:00:00	SPY	ETF	266.155	266.2	266.105	266.125	3602992.0
2017-12-11 14:30:00	SPY	ETF	266.13	266.14	266.04	266.125	2929057.0
2017-12-11 15:00:00	SPY	ETF	266.125	266.14	265.9	265.94	5459094.0
2017-12-11 15:30:00	SPY	ETF	265.945	266.38	265.92	266.34	12106886.0
2017-12-11 16:00:00	SPY	ETF	266.33	266.52	266.28	266.51	13239091.0
2017-12-11 16:30:00	SPY	ETF	266.5	266.77	266.1055	266.63	5789308.0
2017-12-11 17:00:00	SPY	ETF	266.6	266.67	265.9805	266.6	1669654.0
2017-12-11 17:30:00	SPY	ETF	266.63	266.65	266.6	266.64	14170.0
2017-12-11 18:00:00	SPY	ETF	266.63	266.63	266.4	266.43	158219.0
2017-12-11 18:30:00	SPY	ETF	266.43	266.57	266.43	266.53	16798.0
2017-12-11 19:00:00	SPY	ETF	266.55	266.6	266.5	266.56	15896.0
2017-12-11 19:30:00	SPY	ETF	266.58	266.7	266.53	266.53	29100.0
2017-12-11 04:00:00	QQQ	ETF	154.6	154.85	154.6	154.85	300.0
2017-12-11 04:30:00	QQQ	ETF	154.83	154.83	154.71	154.71	9000.0
2017-12-11 05:30:00	QQQ	ETF	154.81	154.85	154.81	154.85	2379.0
2017-12-11 06:00:00	QQQ	ETF	154.78	155.0	154.78	155.0	23380.0
2017-12-11 06:30:00	QQQ	ETF	154.82	154.82	154.73	154.73	13600.0
2017-12-11 07:00:00	QQQ	ETF	154.72	154.87	154.71	154.87	10898.0
2017-12-11 07:30:00	QQQ	ETF	154.85	155.01	154.82	154.84	70389.0
2017-12-11 08:00:00	QQQ	ETF	154.75	154.95	154.57	154.59	211467.0
2017-12-11 08:30:00	QQQ	ETF	154.6	154.79	154.58	154.77	45756.0
2017-12-11 09:00:00	QQQ	ETF	154.75	154.81	154.75	154.77	57886.0
2017-12-11 09:30:00	QQQ	ETF	154.76	155.28	154.76	155.15	2274251.0
2017-12-11 10:00:00	QQQ	ETF	155.15	155.29	155.02	155.13	1596606.0
2017-12-11 10:30:00	QQQ	ETF	155.13	155.32	155.12	155.16	1320572.0
2017-12-11 11:00:00	QQQ	ETF	155.17	155.37	155.02	155.3	920800.0
2017-12-11 11:30:00	QQQ	ETF	155.295	155.51	155.28	155.449	660338.0
2017-12-11 12:00:00	QQQ	ETF	155.45	155.73	155.44	155.72	1149798.0
2017-12-11 12:30:00	QQQ	ETF	155.72	155.92	155.72	155.8953	1153265.0
2017-12-11 13:00:00	QQQ	ETF	155.895	155.95	155.72	155.73	819820.0

> showing 50 of 15,526 rows — these rows as CSV

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