PREVIEW / etf_30min / 2020-05-06

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-05-06.parquet
  size:    541 KB
  rows:    20,022

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
2020-05-06 04:00:00	SPY	ETF	287.76	288.3	287.68	287.68	18240.0
2020-05-06 04:30:00	SPY	ETF	287.87	288.15	287.48	287.94	7872.0
2020-05-06 05:00:00	SPY	ETF	288.03	288.5	287.87	288.26	48496.0
2020-05-06 05:30:00	SPY	ETF	288.28	288.71	288.22	288.71	43345.0
2020-05-06 06:00:00	SPY	ETF	288.75	288.96	288.5	288.6	43965.0
2020-05-06 06:30:00	SPY	ETF	288.6	288.87	288.55	288.65	37712.0
2020-05-06 07:00:00	SPY	ETF	288.66	288.75	288.3	288.37	137736.0
2020-05-06 07:30:00	SPY	ETF	288.38	288.43	287.78	287.78	118383.0
2020-05-06 08:00:00	SPY	ETF	288.35	288.7204	286.06	287.3	474391.0
2020-05-06 08:30:00	SPY	ETF	287.35	287.66	286.87	287.54	423048.0
2020-05-06 09:00:00	SPY	ETF	287.52	288.08	287.52	287.99	547102.0
2020-05-06 09:30:00	SPY	ETF	288.04	288.46	285.83	286.355	7362769.0
2020-05-06 10:00:00	SPY	ETF	286.33	286.61	285.06	286.46	6104528.0
2020-05-06 10:30:00	SPY	ETF	286.47	287.86	286.33	287.17	6140291.0
2020-05-06 11:00:00	SPY	ETF	287.165	287.58	285.72	286.37	4654926.0
2020-05-06 11:30:00	SPY	ETF	286.38	286.82	285.53	286.12	3995572.0
2020-05-06 12:00:00	SPY	ETF	286.1	286.7	285.85	286.51	3367476.0
2020-05-06 12:30:00	SPY	ETF	286.51	287.05	286.41	286.64	2735961.0
2020-05-06 13:00:00	SPY	ETF	286.64	286.81	285.97	286.73	2984165.0
2020-05-06 13:30:00	SPY	ETF	286.75	287.42	286.66	287.01	2621251.0
2020-05-06 14:00:00	SPY	ETF	287.0	287.01	285.92	286.03	3764488.0
2020-05-06 14:30:00	SPY	ETF	286.0329	286.8	285.74	286.256	3677413.0
2020-05-06 15:00:00	SPY	ETF	286.2501	286.58	285.97	286.12	3361131.0
2020-05-06 15:30:00	SPY	ETF	286.115	286.115	283.78	284.29	14602006.0
2020-05-06 16:00:00	SPY	ETF	284.31	284.46	283.4	283.75	4261806.0
2020-05-06 16:30:00	SPY	ETF	283.75	284.05	283.7	283.82	459929.0
2020-05-06 17:00:00	SPY	ETF	283.87	284.25	283.87	284.04	366267.0
2020-05-06 17:30:00	SPY	ETF	284.04	284.25	283.73	283.73	69724.0
2020-05-06 18:00:00	SPY	ETF	283.73	284.17	283.0	283.14	251873.0
2020-05-06 18:30:00	SPY	ETF	283.15	283.42	282.7	283.02	220106.0
2020-05-06 19:00:00	SPY	ETF	283.03	283.28	282.9	283.01	66433.0
2020-05-06 19:30:00	SPY	ETF	283.07	283.7	283.07	283.68	113348.0
2020-05-06 04:00:00	QQQ	ETF	219.06	219.47	219.06	219.12	18958.0
2020-05-06 04:30:00	QQQ	ETF	219.13	219.23	219.0	219.0	6129.0
2020-05-06 05:00:00	QQQ	ETF	219.29	219.57	219.29	219.45	36277.0
2020-05-06 05:30:00	QQQ	ETF	219.44	219.75	219.44	219.75	9784.0
2020-05-06 06:00:00	QQQ	ETF	219.75	219.85	219.56	219.6	8300.0
2020-05-06 06:30:00	QQQ	ETF	219.65	219.7	219.5	219.5	15140.0
2020-05-06 07:00:00	QQQ	ETF	219.54	219.65	219.34	219.45	38458.0
2020-05-06 07:30:00	QQQ	ETF	219.52	219.6	219.24	219.27	50453.0
2020-05-06 08:00:00	QQQ	ETF	219.4201	219.71	217.71	219.0	169319.0
2020-05-06 08:30:00	QQQ	ETF	219.05	219.24	218.61	219.08	129153.0
2020-05-06 09:00:00	QQQ	ETF	219.14	219.55	219.13	219.33	162626.0
2020-05-06 09:30:00	QQQ	ETF	219.37	220.35	218.92	219.37	4466281.0
2020-05-06 10:00:00	QQQ	ETF	219.36	219.53	218.11	219.4499	3068087.0
2020-05-06 10:30:00	QQQ	ETF	219.44	220.78	219.3332	220.345	3416345.0
2020-05-06 11:00:00	QQQ	ETF	220.34	220.7	219.55	220.08	2474741.0
2020-05-06 11:30:00	QQQ	ETF	220.07	220.47	219.44	219.9399	2142717.0
2020-05-06 12:00:00	QQQ	ETF	219.94	220.37	219.72	220.15	1297712.0
2020-05-06 12:30:00	QQQ	ETF	220.18	220.695	220.1	220.3585	1175360.0

> showing 50 of 20,022 rows — these rows as CSV

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