PREVIEW / etf_30min / 2019-10-01

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-10-01.parquet
  size:    524 KB
  rows:    18,216

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-01 04:00:00	SPY	ETF	297.78	297.9	297.58	297.9	11303.0
2019-10-01 04:30:00	SPY	ETF	297.88	298.2	297.78	297.78	7421.0
2019-10-01 05:00:00	SPY	ETF	297.68	297.8	297.43	297.6	11497.0
2019-10-01 05:30:00	SPY	ETF	297.5	297.7	297.43	297.7	5189.0
2019-10-01 06:00:00	SPY	ETF	297.6	297.82	297.48	297.75	14008.0
2019-10-01 06:30:00	SPY	ETF	297.66	297.8	297.42	297.5	13209.0
2019-10-01 07:00:00	SPY	ETF	297.5	297.6	297.4	297.55	26442.0
2019-10-01 07:30:00	SPY	ETF	297.55	297.64	297.46	297.53	23161.0
2019-10-01 08:00:00	SPY	ETF	297.55	298.43	297.4	297.55	74339.0
2019-10-01 08:30:00	SPY	ETF	297.63	297.93	296.77	297.75	256269.0
2019-10-01 09:00:00	SPY	ETF	297.75	297.95	297.62	297.73	497693.0
2019-10-01 09:30:00	SPY	ETF	297.74	298.455	297.58	298.19	7106090.0
2019-10-01 10:00:00	SPY	ETF	298.14	298.19	295.45	296.22	10233787.0
2019-10-01 10:30:00	SPY	ETF	296.21	296.36	295.34	295.41	4078887.0
2019-10-01 11:00:00	SPY	ETF	295.39	295.6	294.85	295.53	4676911.0
2019-10-01 11:30:00	SPY	ETF	295.54	295.63	294.56	294.73	3548591.0
2019-10-01 12:00:00	SPY	ETF	294.73	294.75	293.84	294.19	5078449.0
2019-10-01 12:30:00	SPY	ETF	294.19	294.57	294.05	294.05	2435454.0
2019-10-01 13:00:00	SPY	ETF	294.055	294.11	293.37	293.39	3750521.0
2019-10-01 13:30:00	SPY	ETF	293.44	296.8354	293.06	293.24	5414969.0
2019-10-01 14:00:00	SPY	ETF	293.24	293.61	293.0	293.485	6872539.0
2019-10-01 14:30:00	SPY	ETF	293.485	296.8354	293.48	293.8499	5019482.0
2019-10-01 15:00:00	SPY	ETF	293.84	294.18	293.45	294.02	6472578.0
2019-10-01 15:30:00	SPY	ETF	294.02	294.02	293.09	293.21	16839606.0
2019-10-01 16:00:00	SPY	ETF	293.22	296.8354	292.84	292.95	5122212.0
2019-10-01 16:30:00	SPY	ETF	292.98	293.36	292.94	293.36	210577.0
2019-10-01 17:00:00	SPY	ETF	293.31	293.4	293.24	293.36	911793.0
2019-10-01 17:30:00	SPY	ETF	293.34	293.44	293.34	293.35	94301.0
2019-10-01 18:00:00	SPY	ETF	293.34	293.35	292.93	293.34	385334.0
2019-10-01 18:30:00	SPY	ETF	293.34	293.65	293.34	293.56	42961.0
2019-10-01 19:00:00	SPY	ETF	293.6	293.65	293.47	293.5	4595.0
2019-10-01 19:30:00	SPY	ETF	293.51	293.73	293.43	293.73	34090.0
2019-10-01 04:00:00	QQQ	ETF	189.64	189.64	189.43	189.6	7040.0
2019-10-01 04:30:00	QQQ	ETF	189.59	189.92	189.59	189.92	10694.0
2019-10-01 05:00:00	QQQ	ETF	189.54	189.6	189.29	189.35	11648.0
2019-10-01 05:30:00	QQQ	ETF	189.41	189.5	189.33	189.5	3550.0
2019-10-01 06:00:00	QQQ	ETF	189.41	189.58	189.37	189.46	4200.0
2019-10-01 06:30:00	QQQ	ETF	189.55	189.62	189.36	189.44	15855.0
2019-10-01 07:00:00	QQQ	ETF	189.38	189.49	189.24	189.43	33692.0
2019-10-01 07:30:00	QQQ	ETF	189.46	189.46	189.3	189.39	10409.0
2019-10-01 08:00:00	QQQ	ETF	189.2902	189.88	189.27	189.4	48306.0
2019-10-01 08:30:00	QQQ	ETF	189.43	189.65	189.41	189.51	107398.0
2019-10-01 09:00:00	QQQ	ETF	189.47	189.6205	189.44	189.53	84903.0
2019-10-01 09:30:00	QQQ	ETF	189.54	190.5898	189.44	190.41	3367625.0
2019-10-01 10:00:00	QQQ	ETF	190.4	190.4	188.55	189.17	5496011.0
2019-10-01 10:30:00	QQQ	ETF	189.17	189.17	188.23	188.3	2000010.0
2019-10-01 11:00:00	QQQ	ETF	188.3	188.61	188.01	188.5728	1681242.0
2019-10-01 11:30:00	QQQ	ETF	188.575	188.6368	187.8	187.99	1678505.0
2019-10-01 12:00:00	QQQ	ETF	187.98	187.98	187.41	187.65	1785854.0
2019-10-01 12:30:00	QQQ	ETF	187.65	188.01	187.59	187.6882	1131327.0

> showing 50 of 18,216 rows — these rows as CSV

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