PREVIEW / etf_30min / 2019-08-19

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-08-19.parquet
  size:    515 KB
  rows:    18,160

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-08-19 04:00:00	SPY	ETF	291.34	291.52	291.2	291.2	22695.0
2019-08-19 04:30:00	SPY	ETF	291.16	291.16	291.0	291.06	5893.0
2019-08-19 05:00:00	SPY	ETF	291.14	291.38	291.14	291.38	1250.0
2019-08-19 05:30:00	SPY	ETF	291.39	291.54	291.31	291.49	9274.0
2019-08-19 06:00:00	SPY	ETF	291.55	291.73	291.54	291.56	9223.0
2019-08-19 06:30:00	SPY	ETF	291.55	292.19	291.49	291.81	56796.0
2019-08-19 07:00:00	SPY	ETF	291.82	292.26	291.67	292.25	250763.0
2019-08-19 07:30:00	SPY	ETF	292.17	292.65	292.0	292.07	442408.0
2019-08-19 08:00:00	SPY	ETF	292.08	292.6299	290.46	291.8	346281.0
2019-08-19 08:30:00	SPY	ETF	291.81	292.35	291.81	292.13	219052.0
2019-08-19 09:00:00	SPY	ETF	292.14	292.4	292.0	292.17	379966.0
2019-08-19 09:30:00	SPY	ETF	292.19	292.465	291.77	292.02	6572731.0
2019-08-19 10:00:00	SPY	ETF	292.02	292.08	291.44	291.79	4198145.0
2019-08-19 10:30:00	SPY	ETF	291.79	292.24	291.71	292.09	3194576.0
2019-08-19 11:00:00	SPY	ETF	292.08	292.59	292.08	292.48	2531263.0
2019-08-19 11:30:00	SPY	ETF	292.47	292.71	292.26	292.37	2485649.0
2019-08-19 12:00:00	SPY	ETF	292.36	292.43	292.17	292.345	1448464.0
2019-08-19 12:30:00	SPY	ETF	292.34	292.7	292.16	292.66	2308088.0
2019-08-19 13:00:00	SPY	ETF	292.67	293.08	292.64	292.8501	2381660.0
2019-08-19 13:30:00	SPY	ETF	292.85	292.86	292.57	292.65	2039021.0
2019-08-19 14:00:00	SPY	ETF	292.65	292.68	292.41	292.595	1728710.0
2019-08-19 14:30:00	SPY	ETF	292.61	292.86	292.403	292.61	2258877.0
2019-08-19 15:00:00	SPY	ETF	292.62	292.72	292.37	292.605	3409013.0
2019-08-19 15:30:00	SPY	ETF	292.61	292.91	292.21	292.32	10803760.0
2019-08-19 16:00:00	SPY	ETF	292.32	292.33	292.05	292.26	3507997.0
2019-08-19 16:30:00	SPY	ETF	292.26	292.33	291.98	292.07	251695.0
2019-08-19 17:00:00	SPY	ETF	292.06	292.33	291.97	292.0	70998.0
2019-08-19 17:30:00	SPY	ETF	292.0	292.06	291.96	291.96	32228.0
2019-08-19 18:00:00	SPY	ETF	291.98	292.11	291.85	291.95	51086.0
2019-08-19 18:30:00	SPY	ETF	291.95	292.2	291.95	292.1	12216.0
2019-08-19 19:00:00	SPY	ETF	292.12	292.15	291.98	292.0	4261.0
2019-08-19 19:30:00	SPY	ETF	292.06	292.06	291.64	291.76	41650.0
2019-08-19 04:00:00	QQQ	ETF	187.03	187.35	186.93	187.0	23396.0
2019-08-19 04:30:00	QQQ	ETF	186.97	187.03	186.91	186.91	13700.0
2019-08-19 05:00:00	QQQ	ETF	187.05	187.25	186.97	187.21	23460.0
2019-08-19 05:30:00	QQQ	ETF	187.22	187.4	187.16	187.4	13676.0
2019-08-19 06:00:00	QQQ	ETF	187.34	187.42	187.33	187.35	7510.0
2019-08-19 06:30:00	QQQ	ETF	187.21	187.84	187.2	187.71	55078.0
2019-08-19 07:00:00	QQQ	ETF	187.6	187.89	187.42	187.79	128230.0
2019-08-19 07:30:00	QQQ	ETF	187.78	188.13	187.72	187.87	179156.0
2019-08-19 08:00:00	QQQ	ETF	187.91	188.1099	186.84	187.7	126943.0
2019-08-19 08:30:00	QQQ	ETF	187.71	188.09	185.48	187.98	117144.0
2019-08-19 09:00:00	QQQ	ETF	187.93	188.22	187.89	188.01	150514.0
2019-08-19 09:30:00	QQQ	ETF	188.02	188.7	187.95	188.11	3259231.0
2019-08-19 10:00:00	QQQ	ETF	188.1089	188.17	187.5	187.84	1673646.0
2019-08-19 10:30:00	QQQ	ETF	187.82	188.33	187.8	188.23	1271990.0
2019-08-19 11:00:00	QQQ	ETF	188.21	188.55	188.2043	188.41	1031810.0
2019-08-19 11:30:00	QQQ	ETF	188.41	188.74	188.31	188.49	1136902.0
2019-08-19 12:00:00	QQQ	ETF	188.45	188.51	188.28	188.4	635298.0
2019-08-19 12:30:00	QQQ	ETF	188.4	188.61	188.3	188.6	756205.0

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

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