PREVIEW / etf_30min / 2021-01-21

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-01-21.parquet
  size:    628 KB
  rows:    23,635

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-01-21 04:00:00	SPY	ETF	384.7	384.83	384.6	384.6	5164.0
2021-01-21 04:30:00	SPY	ETF	384.7	384.8	384.7	384.8	1021.0
2021-01-21 05:00:00	SPY	ETF	384.65	384.7	384.6	384.65	2450.0
2021-01-21 05:30:00	SPY	ETF	384.64	384.8	384.44	384.76	6682.0
2021-01-21 06:00:00	SPY	ETF	384.7	384.99	384.7	384.99	5243.0
2021-01-21 06:30:00	SPY	ETF	384.93	385.12	384.75	385.12	18514.0
2021-01-21 07:00:00	SPY	ETF	385.12	385.3	384.94	385.1	115039.0
2021-01-21 07:30:00	SPY	ETF	385.1	385.11	384.74	384.91	36258.0
2021-01-21 08:00:00	SPY	ETF	384.9	385.3	384.72	384.98	55234.0
2021-01-21 08:30:00	SPY	ETF	384.97	384.97	383.8	384.1	337218.0
2021-01-21 09:00:00	SPY	ETF	384.11	384.58	384.07	384.49	127686.0
2021-01-21 09:30:00	SPY	ETF	384.49	384.52	383.25	383.84	4502354.0
2021-01-21 10:00:00	SPY	ETF	383.85	384.83	383.5701	384.77	2780994.0
2021-01-21 10:30:00	SPY	ETF	384.78	384.9	384.62	384.76	1586167.0
2021-01-21 11:00:00	SPY	ETF	384.77	384.95	384.24	384.39	1677634.0
2021-01-21 11:30:00	SPY	ETF	384.3918	384.46	383.66	384.13	1661979.0
2021-01-21 12:00:00	SPY	ETF	384.1109	384.1576	383.2901	383.641	1755972.0
2021-01-21 12:30:00	SPY	ETF	383.63	383.94	383.44	383.93	1405472.0
2021-01-21 13:00:00	SPY	ETF	383.9322	384.2	383.8125	384.0904	1071083.0
2021-01-21 13:30:00	SPY	ETF	384.1	384.34	384.04	384.1799	1146891.0
2021-01-21 14:00:00	SPY	ETF	384.17	384.71	384.11	384.6599	1553569.0
2021-01-21 14:30:00	SPY	ETF	384.65	384.88	384.62	384.84	1615353.0
2021-01-21 15:00:00	SPY	ETF	384.84	384.94	384.48	384.6699	2586965.0
2021-01-21 15:30:00	SPY	ETF	384.66	384.9301	384.06	384.2	5161676.0
2021-01-21 16:00:00	SPY	ETF	384.21	384.4158	384.05	384.05	3086872.0
2021-01-21 16:30:00	SPY	ETF	384.06	384.43	383.93	384.25	225598.0
2021-01-21 17:00:00	SPY	ETF	384.25	384.31	384.11	384.11	255262.0
2021-01-21 17:30:00	SPY	ETF	384.14	384.24	384.07	384.24	40263.0
2021-01-21 18:00:00	SPY	ETF	384.25	384.42	383.83	384.0	136079.0
2021-01-21 18:30:00	SPY	ETF	384.24	384.24	383.84	383.93	21216.0
2021-01-21 19:00:00	SPY	ETF	383.99	384.34	383.86	384.32	25134.0
2021-01-21 19:30:00	SPY	ETF	384.26	384.37	383.61	383.78	52605.0
2021-01-21 04:00:00	QQQ	ETF	325.28	325.6	325.21	325.27	34242.0
2021-01-21 04:30:00	QQQ	ETF	325.35	325.41	325.28	325.28	11642.0
2021-01-21 05:00:00	QQQ	ETF	325.31	325.36	325.05	325.18	28389.0
2021-01-21 05:30:00	QQQ	ETF	325.12	325.45	325.0	325.38	7528.0
2021-01-21 06:00:00	QQQ	ETF	325.33	325.38	325.21	325.33	16545.0
2021-01-21 06:30:00	QQQ	ETF	325.36	325.4	325.1	325.36	55401.0
2021-01-21 07:00:00	QQQ	ETF	325.4	325.56	325.32	325.56	163454.0
2021-01-21 07:30:00	QQQ	ETF	325.57	325.59	325.16	325.39	62681.0
2021-01-21 08:00:00	QQQ	ETF	325.4999	326.46	323.77	325.59	123567.0
2021-01-21 08:30:00	QQQ	ETF	325.54	325.78	324.31	324.61	358293.0
2021-01-21 09:00:00	QQQ	ETF	324.57	325.21	324.54	325.21	213764.0
2021-01-21 09:30:00	QQQ	ETF	325.16	325.26	323.73	324.55	3073756.0
2021-01-21 10:00:00	QQQ	ETF	324.53	326.02	324.34	325.69	2122985.0
2021-01-21 10:30:00	QQQ	ETF	325.69	326.299	325.57	326.23	1647990.0
2021-01-21 11:00:00	QQQ	ETF	326.2401	326.37	325.7	325.99	1071486.0
2021-01-21 11:30:00	QQQ	ETF	326.0	326.12	325.29	325.79	1029394.0
2021-01-21 12:00:00	QQQ	ETF	325.7999	325.87	324.5236	325.0	1341990.0
2021-01-21 12:30:00	QQQ	ETF	324.99	325.59	324.77	325.58	800875.0

> showing 50 of 23,635 rows — these rows as CSV

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