PREVIEW / etf_30min / 2020-10-06

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-10-06.parquet
  size:    573 KB
  rows:    21,176

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-10-06 04:00:00	SPY	ETF	338.75	338.79	338.11	338.48	42106.0
2020-10-06 04:30:00	SPY	ETF	338.5	338.62	338.11	338.44	5272.0
2020-10-06 05:00:00	SPY	ETF	338.4	338.5	338.4	338.47	4004.0
2020-10-06 05:30:00	SPY	ETF	338.49	338.59	338.38	338.39	5677.0
2020-10-06 06:00:00	SPY	ETF	338.26	338.89	338.11	338.7	113507.0
2020-10-06 06:30:00	SPY	ETF	338.71	338.71	338.31	338.57	46724.0
2020-10-06 07:00:00	SPY	ETF	338.64	339.25	338.51	339.17	84548.0
2020-10-06 07:30:00	SPY	ETF	339.2	339.59	339.17	339.43	90607.0
2020-10-06 08:00:00	SPY	ETF	338.6799	339.85	338.0796	339.7	207911.0
2020-10-06 08:30:00	SPY	ETF	339.7	340.2	339.7	339.9	85499.0
2020-10-06 09:00:00	SPY	ETF	339.92	340.11	339.84	339.9104	85085.0
2020-10-06 09:30:00	SPY	ETF	339.91	340.26	339.06	339.41	4583663.0
2020-10-06 10:00:00	SPY	ETF	339.4	340.56	339.38	340.3	3228371.0
2020-10-06 10:30:00	SPY	ETF	340.32	340.56	339.07	339.92	4574889.0
2020-10-06 11:00:00	SPY	ETF	339.92	340.17	338.96	339.38	3411396.0
2020-10-06 11:30:00	SPY	ETF	339.38	339.81	338.66	338.91	2255945.0
2020-10-06 12:00:00	SPY	ETF	338.92	339.74	338.891	339.55	2138790.0
2020-10-06 12:30:00	SPY	ETF	339.56	340.39	339.4	340.31	1682762.0
2020-10-06 13:00:00	SPY	ETF	340.32	341.0	340.19	340.515	2245611.0
2020-10-06 13:30:00	SPY	ETF	340.51	340.87	340.24	340.45	2465157.0
2020-10-06 14:00:00	SPY	ETF	340.47	341.3	340.34	341.14	3778245.0
2020-10-06 14:30:00	SPY	ETF	341.14	342.17	335.71	337.03	17990869.0
2020-10-06 15:00:00	SPY	ETF	337.02	337.02	334.54	336.13	15683825.0
2020-10-06 15:30:00	SPY	ETF	336.12	337.12	334.38	334.94	16467879.0
2020-10-06 16:00:00	SPY	ETF	334.95	335.59	334.86	335.0	4813774.0
2020-10-06 16:30:00	SPY	ETF	334.99	335.25	333.12	333.46	959221.0
2020-10-06 17:00:00	SPY	ETF	333.4	334.93	333.4	333.67	110813.0
2020-10-06 17:30:00	SPY	ETF	333.67	333.85	333.63	333.85	64425.0
2020-10-06 18:00:00	SPY	ETF	333.76	334.24	333.34	334.11	247004.0
2020-10-06 18:30:00	SPY	ETF	334.2	334.61	333.28	333.75	224448.0
2020-10-06 19:00:00	SPY	ETF	333.73	334.44	333.7	334.1899	124261.0
2020-10-06 19:30:00	SPY	ETF	334.16	334.79	334.0	334.62	104672.0
2020-10-06 04:00:00	QQQ	ETF	279.11	279.11	278.51	278.8	50843.0
2020-10-06 04:30:00	QQQ	ETF	278.83	278.93	278.5	278.84	22830.0
2020-10-06 05:00:00	QQQ	ETF	278.72	278.85	278.6	278.67	6320.0
2020-10-06 05:30:00	QQQ	ETF	278.62	278.76	278.6	278.68	14784.0
2020-10-06 06:00:00	QQQ	ETF	278.6	279.05	278.27	278.9	69070.0
2020-10-06 06:30:00	QQQ	ETF	278.93	278.93	278.5	278.79	50747.0
2020-10-06 07:00:00	QQQ	ETF	278.81	279.36	278.75	279.27	65023.0
2020-10-06 07:30:00	QQQ	ETF	279.31	279.49	279.05	279.12	53876.0
2020-10-06 08:00:00	QQQ	ETF	278.8299	280.0	278.4504	279.3	168736.0
2020-10-06 08:30:00	QQQ	ETF	279.25	279.68	279.12	279.29	324933.0
2020-10-06 09:00:00	QQQ	ETF	279.34	279.52	279.17	279.35	189638.0
2020-10-06 09:30:00	QQQ	ETF	279.29	280.07	278.6028	279.29	2937715.0
2020-10-06 10:00:00	QQQ	ETF	279.29	280.56	279.24	280.12	2040877.0
2020-10-06 10:30:00	QQQ	ETF	280.15	280.53	279.0	279.35	2686257.0
2020-10-06 11:00:00	QQQ	ETF	279.358	279.7165	277.59	278.15	2659743.0
2020-10-06 11:30:00	QQQ	ETF	278.12	278.6	277.13	277.6742	2287281.0
2020-10-06 12:00:00	QQQ	ETF	277.6772	278.9399	277.62	278.86	1645456.0
2020-10-06 12:30:00	QQQ	ETF	278.86	279.39	278.56	279.231	982349.0

> showing 50 of 21,176 rows — these rows as CSV

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