PREVIEW / etf_30min / 2021-01-13

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-01-13.parquet
  size:    615 KB
  rows:    23,220

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-13 04:00:00	SPY	ETF	379.26	379.7	379.22	379.58	7912.0
2021-01-13 04:30:00	SPY	ETF	379.64	379.65	379.4	379.51	4473.0
2021-01-13 05:00:00	SPY	ETF	379.48	379.5	378.9	378.92	4298.0
2021-01-13 05:30:00	SPY	ETF	378.85	378.85	378.23	378.73	26152.0
2021-01-13 06:00:00	SPY	ETF	378.75	378.83	378.22	378.22	11840.0
2021-01-13 06:30:00	SPY	ETF	378.28	378.69	377.9	378.4	16906.0
2021-01-13 07:00:00	SPY	ETF	378.46	378.59	377.75	378.0	184683.0
2021-01-13 07:30:00	SPY	ETF	378.07	378.11	377.25	377.53	258127.0
2021-01-13 08:00:00	SPY	ETF	377.56	379.45	377.38	377.96	177332.0
2021-01-13 08:30:00	SPY	ETF	378.05	378.36	378.05	378.32	273339.0
2021-01-13 09:00:00	SPY	ETF	378.3	378.7	378.24	378.7	258113.0
2021-01-13 09:30:00	SPY	ETF	378.69	379.29	378.565	378.848	4035031.0
2021-01-13 10:00:00	SPY	ETF	378.8401	379.31	377.85	379.26	3885443.0
2021-01-13 10:30:00	SPY	ETF	379.2689	379.79	379.16	379.75	3479979.0
2021-01-13 11:00:00	SPY	ETF	379.745	379.94	379.22	379.65	1924855.0
2021-01-13 11:30:00	SPY	ETF	379.645	379.88	379.42	379.59	1500484.0
2021-01-13 12:00:00	SPY	ETF	379.62	379.68	379.09	379.6569	1924521.0
2021-01-13 12:30:00	SPY	ETF	379.65	380.35	379.35	380.1102	2533833.0
2021-01-13 13:00:00	SPY	ETF	380.11	380.36	379.94	380.2199	1358387.0
2021-01-13 13:30:00	SPY	ETF	380.2181	380.37	380.04	380.243	1125564.0
2021-01-13 14:00:00	SPY	ETF	380.24	380.86	379.87	380.77	3331160.0
2021-01-13 14:30:00	SPY	ETF	380.77	380.85	380.11	380.385	2231190.0
2021-01-13 15:00:00	SPY	ETF	380.3844	380.53	379.71	379.76	3041690.0
2021-01-13 15:30:00	SPY	ETF	379.755	380.36	379.61	379.76	7811316.0
2021-01-13 16:00:00	SPY	ETF	379.76	380.23	379.66	380.04	4418763.0
2021-01-13 16:30:00	SPY	ETF	380.04	380.2	380.0	380.07	168686.0
2021-01-13 17:00:00	SPY	ETF	380.15	380.7	380.05	380.7	269255.0
2021-01-13 17:30:00	SPY	ETF	380.69	380.7	380.42	380.54	41469.0
2021-01-13 18:00:00	SPY	ETF	380.53	380.65	380.2	380.36	171430.0
2021-01-13 18:30:00	SPY	ETF	380.35	380.46	380.19	380.19	68348.0
2021-01-13 19:00:00	SPY	ETF	380.18	380.74	380.09	380.61	33636.0
2021-01-13 19:30:00	SPY	ETF	380.74	380.82	380.63	380.7	31186.0
2021-01-13 04:00:00	QQQ	ETF	314.69	315.08	314.69	314.96	31934.0
2021-01-13 04:30:00	QQQ	ETF	314.97	315.06	314.9	314.94	8883.0
2021-01-13 05:00:00	QQQ	ETF	314.93	315.11	314.54	314.59	17327.0
2021-01-13 05:30:00	QQQ	ETF	314.38	314.38	313.77	314.2	17500.0
2021-01-13 06:00:00	QQQ	ETF	314.31	314.33	313.49	313.49	13650.0
2021-01-13 06:30:00	QQQ	ETF	313.58	314.1	313.4	313.71	13656.0
2021-01-13 07:00:00	QQQ	ETF	313.86	314.18	313.55	313.74	81526.0
2021-01-13 07:30:00	QQQ	ETF	313.74	313.74	312.83	313.07	88004.0
2021-01-13 08:00:00	QQQ	ETF	312.99	315.18	312.53	313.14	173808.0
2021-01-13 08:30:00	QQQ	ETF	313.09	313.71	313.09	313.69	73653.0
2021-01-13 09:00:00	QQQ	ETF	313.73	314.23	313.54	314.2	160647.0
2021-01-13 09:30:00	QQQ	ETF	314.19	315.49	313.57	314.705	2731204.0
2021-01-13 10:00:00	QQQ	ETF	314.7499	315.18	313.7099	315.14	1483218.0
2021-01-13 10:30:00	QQQ	ETF	315.14	316.18	315.14	316.16	1614196.0
2021-01-13 11:00:00	QQQ	ETF	316.1501	316.39	315.52	316.17	1183629.0
2021-01-13 11:30:00	QQQ	ETF	316.15	316.64	315.945	316.05	985415.0
2021-01-13 12:00:00	QQQ	ETF	316.0674	316.1	315.5	315.92	836348.0
2021-01-13 12:30:00	QQQ	ETF	315.92	316.25	315.32	316.15	918101.0

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

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