PREVIEW / etf_30min / 2021-02-22

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-02-22.parquet
  size:    650 KB
  rows:    24,869

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-22 04:00:00	SPY	ETF	386.38	387.15	386.3	386.86	62203.0
2021-02-22 04:30:00	SPY	ETF	386.84	387.14	386.45	387.14	8720.0
2021-02-22 05:00:00	SPY	ETF	387.23	387.44	387.15	387.4	10305.0
2021-02-22 05:30:00	SPY	ETF	387.42	387.61	387.1	387.1	28695.0
2021-02-22 06:00:00	SPY	ETF	387.17	387.4	386.89	386.9	20120.0
2021-02-22 06:30:00	SPY	ETF	386.97	387.08	386.7	387.08	55242.0
2021-02-22 07:00:00	SPY	ETF	387.06	387.4	387.04	387.31	117768.0
2021-02-22 07:30:00	SPY	ETF	387.27	387.31	386.38	386.89	335579.0
2021-02-22 08:00:00	SPY	ETF	386.93	389.43	386.08	386.73	301918.0
2021-02-22 08:30:00	SPY	ETF	386.82	387.69	386.82	387.42	335939.0
2021-02-22 09:00:00	SPY	ETF	387.45	387.52	386.59	387.09	442900.0
2021-02-22 09:30:00	SPY	ETF	387.06	388.27	386.74	388.03	6095591.0
2021-02-22 10:00:00	SPY	ETF	388.02	388.59	387.18	387.57	4224598.0
2021-02-22 10:30:00	SPY	ETF	387.57	388.09	386.95	387.277	3518642.0
2021-02-22 11:00:00	SPY	ETF	387.24	388.12	386.9	387.92	3241413.0
2021-02-22 11:30:00	SPY	ETF	387.92	388.25	387.68	388.0399	1504640.0
2021-02-22 12:00:00	SPY	ETF	388.04	388.21	387.57	388.0418	1629345.0
2021-02-22 12:30:00	SPY	ETF	388.0399	388.88	387.84	388.78	1722948.0
2021-02-22 13:00:00	SPY	ETF	388.77	389.24	388.52	389.238	1149108.0
2021-02-22 13:30:00	SPY	ETF	389.22	389.62	389.195	389.39	1659413.0
2021-02-22 14:00:00	SPY	ETF	389.38	389.48	388.9719	389.25	1611240.0
2021-02-22 14:30:00	SPY	ETF	389.23	389.34	388.74	388.91	1672867.0
2021-02-22 15:00:00	SPY	ETF	388.9	388.92	387.63	387.68	3893071.0
2021-02-22 15:30:00	SPY	ETF	387.68	388.08	386.84	387.11	12350279.0
2021-02-22 16:00:00	SPY	ETF	387.1	387.55	386.9682	387.19	5511377.0
2021-02-22 16:30:00	SPY	ETF	387.19	387.5	387.19	387.38	220903.0
2021-02-22 17:00:00	SPY	ETF	387.39	387.39	387.13	387.26	96242.0
2021-02-22 17:30:00	SPY	ETF	387.3	387.35	387.03	387.35	86922.0
2021-02-22 18:00:00	SPY	ETF	387.36	388.0	387.36	387.97	138735.0
2021-02-22 18:30:00	SPY	ETF	387.03	388.0	387.03	387.48	45581.0
2021-02-22 19:00:00	SPY	ETF	387.62	387.62	386.55	387.14	110035.0
2021-02-22 19:30:00	SPY	ETF	387.12	387.34	386.71	386.71	61911.0
2021-02-22 04:00:00	QQQ	ETF	328.73	328.73	326.0	326.79	294376.0
2021-02-22 04:30:00	QQQ	ETF	326.76	327.23	326.54	327.14	33170.0
2021-02-22 05:00:00	QQQ	ETF	327.29	327.51	327.22	327.37	65297.0
2021-02-22 05:30:00	QQQ	ETF	327.32	327.47	326.9	326.92	41490.0
2021-02-22 06:00:00	QQQ	ETF	326.95	327.14	326.48	326.61	98253.0
2021-02-22 06:30:00	QQQ	ETF	326.69	326.71	326.0	326.61	124764.0
2021-02-22 07:00:00	QQQ	ETF	326.61	327.0	326.41	326.87	164799.0
2021-02-22 07:30:00	QQQ	ETF	326.85	326.85	325.89	326.53	150845.0
2021-02-22 08:00:00	QQQ	ETF	326.56	330.01	326.0	326.37	167480.0
2021-02-22 08:30:00	QQQ	ETF	326.44	327.34	326.44	327.04	229837.0
2021-02-22 09:00:00	QQQ	ETF	326.99	327.15	326.08	326.47	291331.0
2021-02-22 09:30:00	QQQ	ETF	326.5	327.63	325.7	327.36	4548716.0
2021-02-22 10:00:00	QQQ	ETF	327.35	327.8	325.23	325.689	2465867.0
2021-02-22 10:30:00	QQQ	ETF	325.68	325.78	323.98	324.28	3383986.0
2021-02-22 11:00:00	QQQ	ETF	324.24	325.37	323.82	325.01	2462207.0
2021-02-22 11:30:00	QQQ	ETF	325.015	325.56	324.53	324.81	1234311.0
2021-02-22 12:00:00	QQQ	ETF	324.81	324.81	323.8	324.145	1401575.0
2021-02-22 12:30:00	QQQ	ETF	324.15	325.28	323.955	325.19	1037838.0

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

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