PREVIEW / etf_30min / 2018-11-27

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-11-27.parquet
  size:    481 KB
  rows:    16,591

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
2018-11-27 04:00:00	SPY	ETF	266.8	267.43	266.65	267.34	43345.0
2018-11-27 04:30:00	SPY	ETF	267.38	267.5	266.84	266.84	15722.0
2018-11-27 05:00:00	SPY	ETF	266.85	266.99	266.65	266.84	12600.0
2018-11-27 05:30:00	SPY	ETF	266.68	266.68	266.46	266.58	31329.0
2018-11-27 06:00:00	SPY	ETF	266.44	266.45	266.06	266.2	30457.0
2018-11-27 06:30:00	SPY	ETF	266.1	266.5	266.1	266.5	46956.0
2018-11-27 07:00:00	SPY	ETF	266.53	266.55	266.13	266.29	111652.0
2018-11-27 07:30:00	SPY	ETF	266.33	266.33	265.87	265.87	169598.0
2018-11-27 08:00:00	SPY	ETF	266.15	268.45	265.71	265.8	198868.0
2018-11-27 08:30:00	SPY	ETF	265.81	266.24	265.66	266.05	373655.0
2018-11-27 09:00:00	SPY	ETF	266.05	266.35	265.91	266.34	388304.0
2018-11-27 09:30:00	SPY	ETF	266.34	266.92	265.66	266.6	7399453.0
2018-11-27 10:00:00	SPY	ETF	266.6	267.73	266.15	267.02	5608090.0
2018-11-27 10:30:00	SPY	ETF	267.01	267.87	266.54	267.4714	4977091.0
2018-11-27 11:00:00	SPY	ETF	267.47	268.03	267.19	267.48	6274285.0
2018-11-27 11:30:00	SPY	ETF	267.47	267.8	267.02	267.63	4401152.0
2018-11-27 12:00:00	SPY	ETF	267.64	267.71	266.65	266.75	2538349.0
2018-11-27 12:30:00	SPY	ETF	266.7462	267.34	266.5	266.8357	3372018.0
2018-11-27 13:00:00	SPY	ETF	266.8315	267.6	266.53	267.0938	6113990.0
2018-11-27 13:30:00	SPY	ETF	267.1	267.72	267.09	267.72	4122873.0
2018-11-27 14:00:00	SPY	ETF	267.72	268.1	267.595	267.9286	2542326.0
2018-11-27 14:30:00	SPY	ETF	267.93	268.18	267.76	267.785	3022609.0
2018-11-27 15:00:00	SPY	ETF	267.78	268.02	267.53	267.793	3731871.0
2018-11-27 15:30:00	SPY	ETF	267.7915	268.37	267.55	268.34	10613437.0
2018-11-27 16:00:00	SPY	ETF	268.32	268.5	268.18	268.49	4014320.0
2018-11-27 16:30:00	SPY	ETF	268.5	268.73	268.47	268.63	1175552.0
2018-11-27 17:00:00	SPY	ETF	268.66	268.76	268.4	268.76	482885.0
2018-11-27 17:30:00	SPY	ETF	268.75	268.78	268.68	268.77	37104.0
2018-11-27 18:00:00	SPY	ETF	268.72	268.89	268.7	268.72	60855.0
2018-11-27 18:30:00	SPY	ETF	268.72	268.72	268.6	268.68	59548.0
2018-11-27 19:00:00	SPY	ETF	268.65	268.84	268.56	268.8	44561.0
2018-11-27 19:30:00	SPY	ETF	268.83	268.84	268.63	268.64	39150.0
2018-11-27 20:00:00	SPY	ETF	268.4	268.61	268.4	268.61	1000.0
2018-11-27 04:00:00	QQQ	ETF	161.74	162.61	161.74	162.61	8862.0
2018-11-27 04:30:00	QQQ	ETF	162.61	162.61	162.26	162.26	5955.0
2018-11-27 05:00:00	QQQ	ETF	162.25	162.34	162.06	162.12	41565.0
2018-11-27 05:30:00	QQQ	ETF	162.09	162.09	161.88	162.06	20374.0
2018-11-27 06:00:00	QQQ	ETF	162.02	162.02	161.66	161.7	18550.0
2018-11-27 06:30:00	QQQ	ETF	161.71	161.98	161.71	161.98	60998.0
2018-11-27 07:00:00	QQQ	ETF	161.99	161.99	161.58	161.64	43777.0
2018-11-27 07:30:00	QQQ	ETF	161.68	161.76	161.44	161.53	72498.0
2018-11-27 08:00:00	QQQ	ETF	162.89	163.1	161.43	161.5	124612.0
2018-11-27 08:30:00	QQQ	ETF	161.54	162.0	161.48	161.82	233800.0
2018-11-27 09:00:00	QQQ	ETF	161.83	162.1	161.76	162.0	130089.0
2018-11-27 09:30:00	QQQ	ETF	162.0	162.58	161.18	162.49	4575294.0
2018-11-27 10:00:00	QQQ	ETF	162.48	163.58	162.08	162.96	4420835.0
2018-11-27 10:30:00	QQQ	ETF	162.94	163.54	162.575	163.35	2511801.0
2018-11-27 11:00:00	QQQ	ETF	163.35	163.85	163.22	163.47	2429489.0
2018-11-27 11:30:00	QQQ	ETF	163.455	163.58	162.91	163.46	1743664.0
2018-11-27 12:00:00	QQQ	ETF	163.47	163.51	162.69	162.73	1360532.0

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

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