PREVIEW / etf_30min / 2020-12-10

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-12-10.parquet
  size:    571 KB
  rows:    21,766

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-12-10 04:00:00	SPY	ETF	367.1	367.96	367.1	367.95	16733.0
2020-12-10 04:30:00	SPY	ETF	367.96	368.09	367.71	367.72	9516.0
2020-12-10 05:00:00	SPY	ETF	367.66	367.89	367.64	367.89	11725.0
2020-12-10 05:30:00	SPY	ETF	367.88	367.93	367.71	367.71	6748.0
2020-12-10 06:00:00	SPY	ETF	367.73	367.78	367.39	367.52	28276.0
2020-12-10 06:30:00	SPY	ETF	367.65	367.66	367.35	367.52	35507.0
2020-12-10 07:00:00	SPY	ETF	367.56	367.58	366.38	366.42	243592.0
2020-12-10 07:30:00	SPY	ETF	366.51	366.64	366.18	366.49	140406.0
2020-12-10 08:00:00	SPY	ETF	366.44	367.87	366.24	366.69	274270.0
2020-12-10 08:30:00	SPY	ETF	366.62	366.63	365.2	365.26	410394.0
2020-12-10 09:00:00	SPY	ETF	365.28	365.49	365.01	365.36	326681.0
2020-12-10 09:30:00	SPY	ETF	365.37	367.38	364.43	367.18	6165279.0
2020-12-10 10:00:00	SPY	ETF	367.18	367.59	366.71	366.9701	2733541.0
2020-12-10 10:30:00	SPY	ETF	366.97	367.71	366.56	367.445	2577944.0
2020-12-10 11:00:00	SPY	ETF	367.45	367.86	366.97	367.56	2768280.0
2020-12-10 11:30:00	SPY	ETF	367.55	367.63	366.205	366.37	2457273.0
2020-12-10 12:00:00	SPY	ETF	366.34	367.16	366.22	366.9313	2159283.0
2020-12-10 12:30:00	SPY	ETF	366.94	367.25	366.3	366.48	3342775.0
2020-12-10 13:00:00	SPY	ETF	366.49	367.38	366.36	367.174	1798220.0
2020-12-10 13:30:00	SPY	ETF	367.175	367.26	366.41	366.58	1977875.0
2020-12-10 14:00:00	SPY	ETF	366.6	366.8	365.75	365.93	3787493.0
2020-12-10 14:30:00	SPY	ETF	365.925	367.2041	365.8	366.015	6498728.0
2020-12-10 15:00:00	SPY	ETF	366.02	367.2041	365.95	366.895	3720947.0
2020-12-10 15:30:00	SPY	ETF	366.89	367.48	366.67	366.72	7895919.0
2020-12-10 16:00:00	SPY	ETF	366.7	366.85	366.18	366.25	4093526.0
2020-12-10 16:30:00	SPY	ETF	366.25	366.73	366.25	366.6	271567.0
2020-12-10 17:00:00	SPY	ETF	366.55	366.73	366.53	366.65	1610666.0
2020-12-10 17:30:00	SPY	ETF	366.65	367.15	366.65	367.13	140772.0
2020-12-10 18:00:00	SPY	ETF	367.1	367.16	366.57	367.01	64864.0
2020-12-10 18:30:00	SPY	ETF	367.06	367.38	367.06	367.22	32416.0
2020-12-10 19:00:00	SPY	ETF	367.2	367.45	367.12	367.12	23363.0
2020-12-10 19:30:00	SPY	ETF	367.15	367.18	366.83	367.09	42091.0
2020-12-10 04:00:00	QQQ	ETF	301.26	301.69	301.1	301.69	23389.0
2020-12-10 04:30:00	QQQ	ETF	301.64	301.68	301.49	301.49	10948.0
2020-12-10 05:00:00	QQQ	ETF	301.58	301.71	301.57	301.69	8400.0
2020-12-10 05:30:00	QQQ	ETF	301.75	301.94	301.51	301.51	14896.0
2020-12-10 06:00:00	QQQ	ETF	301.55	301.64	301.39	301.62	11031.0
2020-12-10 06:30:00	QQQ	ETF	301.67	301.69	301.14	301.22	13912.0
2020-12-10 07:00:00	QQQ	ETF	301.26	301.43	299.8	299.85	122450.0
2020-12-10 07:30:00	QQQ	ETF	300.08	300.23	299.65	299.98	181453.0
2020-12-10 08:00:00	QQQ	ETF	301.23	301.37	299.68	300.37	231508.0
2020-12-10 08:30:00	QQQ	ETF	300.22	300.4	298.95	299.059	318378.0
2020-12-10 09:00:00	QQQ	ETF	299.04	299.3	298.55	299.21	649574.0
2020-12-10 09:30:00	QQQ	ETF	299.21	302.12	298.09	301.9	5028398.0
2020-12-10 10:00:00	QQQ	ETF	301.89	302.99	301.32	302.27	2496769.0
2020-12-10 10:30:00	QQQ	ETF	302.26	303.38	302.0301	303.2	1744354.0
2020-12-10 11:00:00	QQQ	ETF	303.185	303.68	302.6781	303.35	1375860.0
2020-12-10 11:30:00	QQQ	ETF	303.36	303.46	301.85	302.03	1436878.0
2020-12-10 12:00:00	QQQ	ETF	302.03	302.79	301.85	302.235	1003830.0
2020-12-10 12:30:00	QQQ	ETF	302.23	302.72	301.32	301.54	1092942.0

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

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