PREVIEW / etf_30min / 2021-02-24

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-02-24.parquet
  size:    645 KB
  rows:    24,657

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
2021-02-24 04:00:00	SPY	ETF	387.46	388.11	387.14	388.11	30322.0
2021-02-24 04:30:00	SPY	ETF	388.14	388.22	387.84	388.12	5175.0
2021-02-24 05:00:00	SPY	ETF	388.31	388.46	387.87	388.1	13179.0
2021-02-24 05:30:00	SPY	ETF	388.12	388.39	387.99	387.99	33252.0
2021-02-24 06:00:00	SPY	ETF	388.0	388.35	387.8	388.1	38543.0
2021-02-24 06:30:00	SPY	ETF	388.05	388.05	387.55	387.65	48237.0
2021-02-24 07:00:00	SPY	ETF	387.6	389.17	387.6	388.99	199224.0
2021-02-24 07:30:00	SPY	ETF	388.99	389.37	388.58	389.05	165712.0
2021-02-24 08:00:00	SPY	ETF	389.05	389.31	385.4	388.38	236697.0
2021-02-24 08:30:00	SPY	ETF	388.37	388.48	386.0	386.44	471543.0
2021-02-24 09:00:00	SPY	ETF	386.44	386.88	385.85	386.31	593976.0
2021-02-24 09:30:00	SPY	ETF	386.33	387.1734	385.4081	386.39	8459304.0
2021-02-24 10:00:00	SPY	ETF	386.38	387.68	385.27	387.43	6011173.0
2021-02-24 10:30:00	SPY	ETF	387.44	388.625	387.0	388.34	3795739.0
2021-02-24 11:00:00	SPY	ETF	388.35	389.95	388.26	389.39	4463549.0
2021-02-24 11:30:00	SPY	ETF	389.39	390.07	389.32	389.9219	3013273.0
2021-02-24 12:00:00	SPY	ETF	389.92	390.89	389.92	390.89	3181675.0
2021-02-24 12:30:00	SPY	ETF	390.89	391.21	390.46	390.485	2682818.0
2021-02-24 13:00:00	SPY	ETF	390.49	391.45	390.17	391.39	2607170.0
2021-02-24 13:30:00	SPY	ETF	391.405	392.1101	391.33	392.0	2721995.0
2021-02-24 14:00:00	SPY	ETF	392.0	392.16	391.11	391.53	2957840.0
2021-02-24 14:30:00	SPY	ETF	391.539	391.8299	390.99	391.15	1966786.0
2021-02-24 15:00:00	SPY	ETF	391.17	391.9	391.04	391.866	2317795.0
2021-02-24 15:30:00	SPY	ETF	391.86	392.23	391.43	391.76	8859061.0
2021-02-24 16:00:00	SPY	ETF	391.76	392.65	391.68	392.38	4073695.0
2021-02-24 16:30:00	SPY	ETF	392.39	392.4	391.77	392.01	223422.0
2021-02-24 17:00:00	SPY	ETF	392.1	392.1	391.8	391.93	120069.0
2021-02-24 17:30:00	SPY	ETF	391.9	391.94	391.78	391.83	98398.0
2021-02-24 18:00:00	SPY	ETF	391.84	392.16	391.77	392.12	60545.0
2021-02-24 18:30:00	SPY	ETF	391.77	393.1	391.77	392.94	115743.0
2021-02-24 19:00:00	SPY	ETF	392.94	392.96	392.51	392.8	30974.0
2021-02-24 19:30:00	SPY	ETF	392.79	392.79	392.37	392.63	36702.0
2021-02-24 04:00:00	QQQ	ETF	321.48	322.58	321.13	322.56	44655.0
2021-02-24 04:30:00	QQQ	ETF	322.6	322.67	322.02	322.21	17042.0
2021-02-24 05:00:00	QQQ	ETF	322.22	322.83	321.5	322.39	52754.0
2021-02-24 05:30:00	QQQ	ETF	322.36	322.74	322.19	322.26	34178.0
2021-02-24 06:00:00	QQQ	ETF	322.26	322.35	321.71	322.0	37062.0
2021-02-24 06:30:00	QQQ	ETF	322.0	322.0	320.96	321.19	92041.0
2021-02-24 07:00:00	QQQ	ETF	321.25	323.37	321.23	323.18	210053.0
2021-02-24 07:30:00	QQQ	ETF	323.25	324.13	322.83	323.76	268588.0
2021-02-24 08:00:00	QQQ	ETF	323.8	324.11	317.54	322.54	462744.0
2021-02-24 08:30:00	QQQ	ETF	322.56	322.56	318.301	319.04	1126409.0
2021-02-24 09:00:00	QQQ	ETF	319.04	319.71	317.85	318.8	968817.0
2021-02-24 09:30:00	QQQ	ETF	318.81	319.9	317.025	317.71	8859754.0
2021-02-24 10:00:00	QQQ	ETF	317.74	319.295	315.96	318.94	4921625.0
2021-02-24 10:30:00	QQQ	ETF	319.0	319.83	317.97	319.53	2521091.0
2021-02-24 11:00:00	QQQ	ETF	319.56	321.48	319.18	320.87	2841578.0
2021-02-24 11:30:00	QQQ	ETF	320.88	321.76	320.45	321.455	1773201.0
2021-02-24 12:00:00	QQQ	ETF	321.45	322.59	321.45	322.58	1876711.0
2021-02-24 12:30:00	QQQ	ETF	322.58	323.13	321.95	322.005	1637207.0

> showing 50 of 24,657 rows — these rows as CSV

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