PREVIEW / etf_30min / 2019-05-03

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-05-03.parquet
  size:    487 KB
  rows:    16,919

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-03 04:00:00	SPY	ETF	291.97	292.29	291.97	292.29	4267.0
2019-05-03 04:30:00	SPY	ETF	292.17	292.19	292.15	292.16	2135.0
2019-05-03 05:00:00	SPY	ETF	292.19	292.26	292.15	292.19	7150.0
2019-05-03 05:30:00	SPY	ETF	292.14	292.18	291.95	291.96	6140.0
2019-05-03 06:00:00	SPY	ETF	291.96	292.06	291.91	292.03	7333.0
2019-05-03 06:30:00	SPY	ETF	292.05	292.09	291.94	291.94	42440.0
2019-05-03 07:00:00	SPY	ETF	291.94	292.07	291.89	292.05	26150.0
2019-05-03 07:30:00	SPY	ETF	291.98	292.19	291.98	292.14	35213.0
2019-05-03 08:00:00	SPY	ETF	292.02	292.28	291.65	292.18	298049.0
2019-05-03 08:30:00	SPY	ETF	292.2	292.83	291.75	292.73	1246411.0
2019-05-03 09:00:00	SPY	ETF	292.75	292.84	292.51	292.81	275637.0
2019-05-03 09:30:00	SPY	ETF	292.82	293.14	292.56	293.05	6663968.0
2019-05-03 10:00:00	SPY	ETF	293.04	293.31	292.58	292.8076	4340997.0
2019-05-03 10:30:00	SPY	ETF	292.8199	293.39	292.819	293.37	3202427.0
2019-05-03 11:00:00	SPY	ETF	293.37	293.7	293.19	293.3	3274415.0
2019-05-03 11:30:00	SPY	ETF	293.31	293.67	293.2	293.575	1976962.0
2019-05-03 12:00:00	SPY	ETF	293.5701	293.95	293.53	293.92	2216898.0
2019-05-03 12:30:00	SPY	ETF	293.9149	294.03	293.785	293.9	2071927.0
2019-05-03 13:00:00	SPY	ETF	293.9	294.176	293.8	294.155	2026588.0
2019-05-03 13:30:00	SPY	ETF	294.155	294.34	294.105	294.19	1756062.0
2019-05-03 14:00:00	SPY	ETF	294.18	294.18	293.97	294.0799	1591730.0
2019-05-03 14:30:00	SPY	ETF	294.08	294.19	293.91	293.98	1649404.0
2019-05-03 15:00:00	SPY	ETF	293.97	294.0	293.75	293.97	6918490.0
2019-05-03 15:30:00	SPY	ETF	293.96	294.2	293.87	294.02	7691134.0
2019-05-03 16:00:00	SPY	ETF	294.02	294.4536	293.96	294.22	6591511.0
2019-05-03 16:30:00	SPY	ETF	294.25	294.39	293.65	294.35	492063.0
2019-05-03 17:00:00	SPY	ETF	294.35	294.38	294.03	294.32	184408.0
2019-05-03 17:30:00	SPY	ETF	294.28	294.37	294.19	294.22	549803.0
2019-05-03 18:00:00	SPY	ETF	294.23	294.25	294.03	294.03	1860.0
2019-05-03 18:30:00	SPY	ETF	294.19	294.24	294.19	294.22	5405.0
2019-05-03 19:00:00	SPY	ETF	294.23	294.29	294.22	294.29	6301.0
2019-05-03 19:30:00	SPY	ETF	294.28	294.34	294.25	294.34	15394.0
2019-05-03 04:00:00	QQQ	ETF	189.05	189.2	189.05	189.17	5250.0
2019-05-03 04:30:00	QQQ	ETF	189.19	189.19	189.09	189.14	9086.0
2019-05-03 05:00:00	QQQ	ETF	189.13	189.2	189.13	189.13	4980.0
2019-05-03 05:30:00	QQQ	ETF	189.16	189.2	189.02	189.02	6195.0
2019-05-03 06:00:00	QQQ	ETF	189.05	189.13	189.0	189.13	4090.0
2019-05-03 06:30:00	QQQ	ETF	189.17	189.24	189.1	189.11	16693.0
2019-05-03 07:00:00	QQQ	ETF	189.11	189.2	189.08	189.15	42224.0
2019-05-03 07:30:00	QQQ	ETF	189.14	189.34	189.14	189.31	68437.0
2019-05-03 08:00:00	QQQ	ETF	189.11	189.45	188.81	189.29	583350.0
2019-05-03 08:30:00	QQQ	ETF	189.45	189.69	188.9	189.65	1044338.0
2019-05-03 09:00:00	QQQ	ETF	189.67	189.74	189.48	189.66	173056.0
2019-05-03 09:30:00	QQQ	ETF	189.68	189.97	189.33	189.91	3076951.0
2019-05-03 10:00:00	QQQ	ETF	189.915	190.23	189.7299	190.09	2112954.0
2019-05-03 10:30:00	QQQ	ETF	190.09	190.58	190.03	190.55	1636421.0
2019-05-03 11:00:00	QQQ	ETF	190.56	190.83	190.3279	190.41	2511057.0
2019-05-03 11:30:00	QQQ	ETF	190.4	190.61	190.32	190.485	1216258.0
2019-05-03 12:00:00	QQQ	ETF	190.48	190.77	190.37	190.765	1159815.0
2019-05-03 12:30:00	QQQ	ETF	190.765	190.88	190.55	190.72	991291.0

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

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