PREVIEW / etf_30min / 2019-10-31

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-10-31.parquet
  size:    512 KB
  rows:    17,783

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
2019-10-31 04:00:00	SPY	ETF	304.63	304.81	304.57	304.64	18085.0
2019-10-31 04:30:00	SPY	ETF	304.61	304.69	304.54	304.62	3700.0
2019-10-31 05:00:00	SPY	ETF	304.64	304.64	303.44	303.64	33375.0
2019-10-31 05:30:00	SPY	ETF	303.53	303.6	303.1	303.45	19670.0
2019-10-31 06:00:00	SPY	ETF	303.31	303.51	303.3	303.41	26557.0
2019-10-31 06:30:00	SPY	ETF	303.41	303.7	303.35	303.55	31130.0
2019-10-31 07:00:00	SPY	ETF	303.66	303.75	303.48	303.57	82835.0
2019-10-31 07:30:00	SPY	ETF	303.5	303.68	303.25	303.51	99270.0
2019-10-31 08:00:00	SPY	ETF	303.47	304.51	303.3	303.74	223566.0
2019-10-31 08:30:00	SPY	ETF	303.78	304.1	303.7	303.97	216942.0
2019-10-31 09:00:00	SPY	ETF	303.93	304.29	303.83	304.08	313412.0
2019-10-31 09:30:00	SPY	ETF	304.13	304.13	303.26	303.28	6030298.0
2019-10-31 10:00:00	SPY	ETF	303.27	303.2861	302.275	302.46	5929211.0
2019-10-31 10:30:00	SPY	ETF	302.4597	302.81	301.73	302.8	5534280.0
2019-10-31 11:00:00	SPY	ETF	302.81	303.02	302.47	302.62	3332455.0
2019-10-31 11:30:00	SPY	ETF	302.61	302.94	302.35	302.675	3209003.0
2019-10-31 12:00:00	SPY	ETF	302.68	302.783	302.11	302.4	3100400.0
2019-10-31 12:30:00	SPY	ETF	302.4	302.42	301.85	302.2	3956173.0
2019-10-31 13:00:00	SPY	ETF	302.21	302.53	302.11	302.5	2031340.0
2019-10-31 13:30:00	SPY	ETF	302.5	302.68	302.34	302.36	1467176.0
2019-10-31 14:00:00	SPY	ETF	302.35	302.425	302.01	302.35	2643163.0
2019-10-31 14:30:00	SPY	ETF	302.345	302.47	301.85	302.32	3694506.0
2019-10-31 15:00:00	SPY	ETF	302.31	302.73	302.21	302.45	4312959.0
2019-10-31 15:30:00	SPY	ETF	302.46	303.39	302.38	303.26	12098429.0
2019-10-31 16:00:00	SPY	ETF	303.29	303.53	303.18	303.28	7136518.0
2019-10-31 16:30:00	SPY	ETF	303.26	303.52	303.22	303.26	1557163.0
2019-10-31 17:00:00	SPY	ETF	303.26	303.36	303.22	303.3	391637.0
2019-10-31 17:30:00	SPY	ETF	303.3	303.36	303.28	303.34	31089.0
2019-10-31 18:00:00	SPY	ETF	303.33	303.33	303.07	303.14	60937.0
2019-10-31 18:30:00	SPY	ETF	303.17	303.22	303.07	303.14	15850.0
2019-10-31 19:00:00	SPY	ETF	303.13	303.18	303.1	303.18	5553.0
2019-10-31 19:30:00	SPY	ETF	303.1	303.3	303.1	303.2	12780.0
2019-10-31 04:00:00	QQQ	ETF	197.94	198.13	197.94	197.96	27894.0
2019-10-31 04:30:00	QQQ	ETF	198.0	198.0	197.85	197.96	36650.0
2019-10-31 05:00:00	QQQ	ETF	197.96	198.01	197.07	197.22	36771.0
2019-10-31 05:30:00	QQQ	ETF	197.21	197.21	196.81	197.04	31709.0
2019-10-31 06:00:00	QQQ	ETF	197.06	197.11	196.95	197.05	30130.0
2019-10-31 06:30:00	QQQ	ETF	197.03	197.26	196.94	197.2	19570.0
2019-10-31 07:00:00	QQQ	ETF	197.24	197.25	196.99	197.12	27742.0
2019-10-31 07:30:00	QQQ	ETF	197.11	197.21	196.9	197.08	43249.0
2019-10-31 08:00:00	QQQ	ETF	197.23	197.93	196.9201	197.2	115947.0
2019-10-31 08:30:00	QQQ	ETF	197.23	197.51	197.17	197.46	73820.0
2019-10-31 09:00:00	QQQ	ETF	197.39	197.6	197.35	197.5	185654.0
2019-10-31 09:30:00	QQQ	ETF	197.56	197.65	196.91	196.93	4115402.0
2019-10-31 10:00:00	QQQ	ETF	196.9346	197.08	196.2	196.395	2359969.0
2019-10-31 10:30:00	QQQ	ETF	196.39	196.85	195.94	196.83	2978946.0
2019-10-31 11:00:00	QQQ	ETF	196.83	197.15	196.675	196.82	2090010.0
2019-10-31 11:30:00	QQQ	ETF	196.815	197.11	196.66	196.705	804531.0
2019-10-31 12:00:00	QQQ	ETF	196.71	196.79	196.37	196.59	845780.0
2019-10-31 12:30:00	QQQ	ETF	196.59	196.6	196.21	196.4	869747.0

> showing 50 of 17,783 rows — these rows as CSV

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