PREVIEW / etf_30min / 2019-10-17

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-10-17.parquet
  size:    499 KB
  rows:    17,418

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-17 04:00:00	SPY	ETF	298.75	298.95	298.67	298.8	5010.0
2019-10-17 04:30:00	SPY	ETF	298.78	299.22	298.78	299.22	5586.0
2019-10-17 05:00:00	SPY	ETF	298.84	299.06	298.84	299.06	430.0
2019-10-17 05:30:00	SPY	ETF	299.19	300.05	299.19	299.82	35648.0
2019-10-17 06:00:00	SPY	ETF	299.85	300.1	299.78	299.8	23570.0
2019-10-17 06:30:00	SPY	ETF	299.71	299.83	299.58	299.68	13939.0
2019-10-17 07:00:00	SPY	ETF	299.68	299.86	299.33	299.76	97821.0
2019-10-17 07:30:00	SPY	ETF	299.83	299.85	299.5	299.5	72356.0
2019-10-17 08:00:00	SPY	ETF	299.53	299.8099	298.15	299.35	172885.0
2019-10-17 08:30:00	SPY	ETF	299.34	299.7	298.4	299.56	144559.0
2019-10-17 09:00:00	SPY	ETF	299.6	299.76	299.38	299.69	323063.0
2019-10-17 09:30:00	SPY	ETF	299.68	300.2	299.44	300.09	3982381.0
2019-10-17 10:00:00	SPY	ETF	300.08	300.24	299.72	299.92	4001880.0
2019-10-17 10:30:00	SPY	ETF	299.93	299.95	299.18	299.25	3688720.0
2019-10-17 11:00:00	SPY	ETF	299.23	299.56	298.7	299.325	6106466.0
2019-10-17 11:30:00	SPY	ETF	299.34	299.37	298.64	298.91	3266882.0
2019-10-17 12:00:00	SPY	ETF	298.91	299.03	298.515	298.934	2463523.0
2019-10-17 12:30:00	SPY	ETF	298.93	299.31	298.9207	299.3	1204657.0
2019-10-17 13:00:00	SPY	ETF	299.2911	299.44	299.1	299.25	1451288.0
2019-10-17 13:30:00	SPY	ETF	299.25	299.51	299.24	299.38	2030082.0
2019-10-17 14:00:00	SPY	ETF	299.39	299.435	299.01	299.35	2207736.0
2019-10-17 14:30:00	SPY	ETF	299.36	299.68	299.15	299.58	2068983.0
2019-10-17 15:00:00	SPY	ETF	299.58	299.68	299.35	299.47	1923293.0
2019-10-17 15:30:00	SPY	ETF	299.475	299.64	299.07	299.24	6826727.0
2019-10-17 16:00:00	SPY	ETF	299.23	299.28	299.11	299.22	2777691.0
2019-10-17 16:30:00	SPY	ETF	299.21	299.34	299.18	299.27	218964.0
2019-10-17 17:00:00	SPY	ETF	299.27	299.35	299.25	299.34	21364.0
2019-10-17 17:30:00	SPY	ETF	299.33	299.33	299.2	299.23	703406.0
2019-10-17 18:00:00	SPY	ETF	299.23	299.24	298.95	299.12	50944.0
2019-10-17 18:30:00	SPY	ETF	299.2	299.26	299.15	299.15	27797.0
2019-10-17 19:00:00	SPY	ETF	299.14	299.2	299.04	299.13	14897.0
2019-10-17 19:30:00	SPY	ETF	299.11	299.16	299.06	299.16	12707.0
2019-10-17 04:00:00	QQQ	ETF	193.51	193.71	193.45	193.63	12290.0
2019-10-17 04:30:00	QQQ	ETF	193.56	193.87	193.56	193.68	4337.0
2019-10-17 05:00:00	QQQ	ETF	193.65	193.83	193.5	193.83	1793.0
2019-10-17 05:30:00	QQQ	ETF	193.81	194.5	193.81	194.37	70113.0
2019-10-17 06:00:00	QQQ	ETF	194.35	194.54	194.27	194.31	22112.0
2019-10-17 06:30:00	QQQ	ETF	194.15	194.33	194.14	194.2	8583.0
2019-10-17 07:00:00	QQQ	ETF	194.15	194.39	193.96	194.39	58537.0
2019-10-17 07:30:00	QQQ	ETF	194.36	194.37	194.12	194.12	96895.0
2019-10-17 08:00:00	QQQ	ETF	194.16	194.3501	193.16	194.09	91531.0
2019-10-17 08:30:00	QQQ	ETF	194.1	194.35	194.0	194.3	147284.0
2019-10-17 09:00:00	QQQ	ETF	194.31	194.32	194.09	194.19	42960.0
2019-10-17 09:30:00	QQQ	ETF	194.18	194.5	193.88	194.32	1949085.0
2019-10-17 10:00:00	QQQ	ETF	194.33	194.34	193.68	193.85	1304089.0
2019-10-17 10:30:00	QQQ	ETF	193.845	193.87	193.19	193.36	1353589.0
2019-10-17 11:00:00	QQQ	ETF	193.36	193.61	192.97	193.4	1266732.0
2019-10-17 11:30:00	QQQ	ETF	193.43	193.45	192.89	193.1423	1141318.0
2019-10-17 12:00:00	QQQ	ETF	193.16	193.29	192.81	193.21	719415.0
2019-10-17 12:30:00	QQQ	ETF	193.21	193.46	193.21	193.44	451708.0

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

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