PREVIEW / etf_30min / 2019-05-24

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-05-24.parquet
  size:    475 KB
  rows:    16,579

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-05-24 04:00:00	SPY	ETF	283.36	283.77	283.36	283.7	20869.0
2019-05-24 04:30:00	SPY	ETF	283.67	283.84	283.6	283.61	4437.0
2019-05-24 05:00:00	SPY	ETF	283.64	283.83	283.59	283.62	8250.0
2019-05-24 05:30:00	SPY	ETF	283.63	283.67	283.45	283.66	5975.0
2019-05-24 06:00:00	SPY	ETF	283.67	283.9	283.67	283.9	14908.0
2019-05-24 06:30:00	SPY	ETF	283.9	284.0	283.71	283.76	71763.0
2019-05-24 07:00:00	SPY	ETF	283.72	283.85	283.68	283.73	131012.0
2019-05-24 07:30:00	SPY	ETF	283.71	283.91	283.28	283.29	494803.0
2019-05-24 08:00:00	SPY	ETF	283.74	283.91	282.81	283.35	234342.0
2019-05-24 08:30:00	SPY	ETF	283.35	283.4	283.1	283.4	136194.0
2019-05-24 09:00:00	SPY	ETF	283.41	283.79	283.38	283.73	509600.0
2019-05-24 09:30:00	SPY	ETF	283.74	284.2	283.37	283.61	6852843.0
2019-05-24 10:00:00	SPY	ETF	283.62	283.83	283.08	283.08	3639547.0
2019-05-24 10:30:00	SPY	ETF	283.0811	283.31	282.28	282.33	5033116.0
2019-05-24 11:00:00	SPY	ETF	282.33	282.65	282.09	282.4014	3638984.0
2019-05-24 11:30:00	SPY	ETF	282.42	282.94	282.395	282.761	2598276.0
2019-05-24 12:00:00	SPY	ETF	282.77	283.03	282.51	282.99	3609893.0
2019-05-24 12:30:00	SPY	ETF	283.0	283.39	282.9881	283.39	1789557.0
2019-05-24 13:00:00	SPY	ETF	283.39	283.49	283.0	283.02	1509543.0
2019-05-24 13:30:00	SPY	ETF	283.03	283.42	283.01	283.1	1416311.0
2019-05-24 14:00:00	SPY	ETF	283.1	283.1599	282.68	282.87	3092454.0
2019-05-24 14:30:00	SPY	ETF	282.865	283.12	282.83	282.95	1880356.0
2019-05-24 15:00:00	SPY	ETF	282.96	283.17	282.89	283.13	2265077.0
2019-05-24 15:30:00	SPY	ETF	283.13	283.13	282.53	282.8	6949671.0
2019-05-24 16:00:00	SPY	ETF	282.81	283.2	282.6972	283.17	5494069.0
2019-05-24 16:30:00	SPY	ETF	283.17	283.21	282.78	283.03	432404.0
2019-05-24 17:00:00	SPY	ETF	283.09	283.14	283.03	283.03	16991.0
2019-05-24 17:30:00	SPY	ETF	283.05	283.08	282.78	283.0	2382871.0
2019-05-24 18:00:00	SPY	ETF	283.0	283.01	282.9	282.9	23471.0
2019-05-24 18:30:00	SPY	ETF	282.97	282.99	282.9	282.92	2777.0
2019-05-24 19:00:00	SPY	ETF	282.9101	282.96	282.9	282.96	5335.0
2019-05-24 19:30:00	SPY	ETF	282.99	282.99	282.92	282.96	11428.0
2019-05-24 04:00:00	QQQ	ETF	179.12	179.4	179.12	179.31	15297.0
2019-05-24 04:30:00	QQQ	ETF	179.31	179.39	179.22	179.22	13180.0
2019-05-24 05:00:00	QQQ	ETF	179.22	179.39	179.13	179.14	2260.0
2019-05-24 05:30:00	QQQ	ETF	179.2	179.25	179.07	179.25	11890.0
2019-05-24 06:00:00	QQQ	ETF	179.3	179.35	179.2	179.34	8159.0
2019-05-24 06:30:00	QQQ	ETF	179.32	179.35	179.2	179.23	10000.0
2019-05-24 07:00:00	QQQ	ETF	179.22	179.29	179.15	179.2	42389.0
2019-05-24 07:30:00	QQQ	ETF	179.24	179.26	178.79	178.82	169923.0
2019-05-24 08:00:00	QQQ	ETF	178.82	179.23	178.62	178.94	181808.0
2019-05-24 08:30:00	QQQ	ETF	178.87	178.99	178.25	178.99	675848.0
2019-05-24 09:00:00	QQQ	ETF	178.99	179.31	178.895	179.31	212403.0
2019-05-24 09:30:00	QQQ	ETF	179.3	179.85	179.21	179.4899	3026275.0
2019-05-24 10:00:00	QQQ	ETF	179.48	179.68	178.9136	178.92	1478878.0
2019-05-24 10:30:00	QQQ	ETF	178.92	179.06	178.29	178.42	1968023.0
2019-05-24 11:00:00	QQQ	ETF	178.41	178.635	178.18	178.47	1424918.0
2019-05-24 11:30:00	QQQ	ETF	178.47	178.8691	178.44	178.685	1025107.0
2019-05-24 12:00:00	QQQ	ETF	178.69	178.85	178.41	178.83	974476.0
2019-05-24 12:30:00	QQQ	ETF	178.84	179.07	178.81	179.01	1046595.0

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

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