PREVIEW / etf_30min / 2020-02-21

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-02-21.parquet
  size:    546 KB
  rows:    19,284

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-02-21 04:00:00	SPY	ETF	335.41	335.52	335.1	335.2	11898.0
2020-02-21 04:30:00	SPY	ETF	335.35	335.43	334.89	334.96	16374.0
2020-02-21 05:00:00	SPY	ETF	335.05	335.56	335.05	335.52	20723.0
2020-02-21 05:30:00	SPY	ETF	335.44	335.69	335.39	335.54	5243.0
2020-02-21 06:00:00	SPY	ETF	335.45	335.45	335.17	335.4	32158.0
2020-02-21 06:30:00	SPY	ETF	335.45	335.7	335.4	335.4	20787.0
2020-02-21 07:00:00	SPY	ETF	335.47	335.59	335.36	335.56	67447.0
2020-02-21 07:30:00	SPY	ETF	335.56	335.98	335.55	335.82	71200.0
2020-02-21 08:00:00	SPY	ETF	335.5	335.95	334.32	335.56	144692.0
2020-02-21 08:30:00	SPY	ETF	335.57	335.59	335.26	335.3	220345.0
2020-02-21 09:00:00	SPY	ETF	335.28	335.82	335.26	335.49	482936.0
2020-02-21 09:30:00	SPY	ETF	335.47	335.81	333.43	334.1	16446091.0
2020-02-21 10:00:00	SPY	ETF	334.09	334.59	333.55	334.2	9730472.0
2020-02-21 10:30:00	SPY	ETF	334.19	334.24	333.02	333.84	9241087.0
2020-02-21 11:00:00	SPY	ETF	333.84	334.37	333.7	334.27	4815432.0
2020-02-21 11:30:00	SPY	ETF	334.27	334.73	334.16	334.41	4037389.0
2020-02-21 12:00:00	SPY	ETF	334.41	334.82	334.08	334.17	3530001.0
2020-02-21 12:30:00	SPY	ETF	334.155	334.29	333.775	333.98	3581589.0
2020-02-21 13:00:00	SPY	ETF	333.97	334.28	333.51	333.51	4894556.0
2020-02-21 13:30:00	SPY	ETF	333.52	333.56	332.59	333.08	6427725.0
2020-02-21 14:00:00	SPY	ETF	333.0667	333.44	332.75	333.28	5758083.0
2020-02-21 14:30:00	SPY	ETF	333.28	333.54	333.04	333.33	4440904.0
2020-02-21 15:00:00	SPY	ETF	333.29	333.43	332.8	332.99	5606453.0
2020-02-21 15:30:00	SPY	ETF	332.99	333.94	332.58	333.49	14597851.0
2020-02-21 16:00:00	SPY	ETF	333.5	333.83	333.43	333.74	16084923.0
2020-02-21 16:30:00	SPY	ETF	333.75	333.76	333.48	333.59	1693905.0
2020-02-21 17:00:00	SPY	ETF	333.59	337.0594	333.48	333.48	348570.0
2020-02-21 17:30:00	SPY	ETF	333.47	333.54	333.43	333.48	143817.0
2020-02-21 18:00:00	SPY	ETF	333.48	333.59	333.39	333.46	55477.0
2020-02-21 18:30:00	SPY	ETF	333.48	333.53	333.48	333.49	19011.0
2020-02-21 19:00:00	SPY	ETF	333.49	333.5	333.39	333.39	23597.0
2020-02-21 19:30:00	SPY	ETF	333.38	333.45	333.32	333.32	22588.0
2020-02-21 04:00:00	QQQ	ETF	233.36	233.55	233.12	233.15	37864.0
2020-02-21 04:30:00	QQQ	ETF	233.2	233.37	232.93	232.99	18463.0
2020-02-21 05:00:00	QQQ	ETF	233.16	233.5	233.16	233.5	12848.0
2020-02-21 05:30:00	QQQ	ETF	233.35	233.59	233.3	233.56	8675.0
2020-02-21 06:00:00	QQQ	ETF	233.46	233.52	233.22	233.31	8986.0
2020-02-21 06:30:00	QQQ	ETF	233.44	233.64	233.4	233.45	17100.0
2020-02-21 07:00:00	QQQ	ETF	233.48	233.6	233.39	233.58	56931.0
2020-02-21 07:30:00	QQQ	ETF	233.55	234.03	233.55	233.9	101237.0
2020-02-21 08:00:00	QQQ	ETF	233.4401	234.0299	232.75	233.7	146554.0
2020-02-21 08:30:00	QQQ	ETF	233.74	233.82	233.53	233.63	117864.0
2020-02-21 09:00:00	QQQ	ETF	233.61	234.08	233.59	233.59	237918.0
2020-02-21 09:30:00	QQQ	ETF	233.65	234.01	231.01	231.79	7810825.0
2020-02-21 10:00:00	QQQ	ETF	231.78	232.23	231.295	232.0	3850177.0
2020-02-21 10:30:00	QQQ	ETF	232.0	232.07	230.82	231.63	3265758.0
2020-02-21 11:00:00	QQQ	ETF	231.665	232.0	231.341	231.958	1868580.0
2020-02-21 11:30:00	QQQ	ETF	231.95	232.17	231.66	231.86	1958671.0
2020-02-21 12:00:00	QQQ	ETF	231.88	232.34	231.49	231.58	1628711.0
2020-02-21 12:30:00	QQQ	ETF	231.55	231.65	230.93	231.13	1491582.0

> showing 50 of 19,284 rows — these rows as CSV

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