PREVIEW / etf_30min / 2021-01-08

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-01-08.parquet
  size:    635 KB
  rows:    24,043

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-08 04:00:00	SPY	ETF	380.2	380.23	379.47	379.48	28894.0
2021-01-08 04:30:00	SPY	ETF	379.6	380.16	379.5	380.16	11421.0
2021-01-08 05:00:00	SPY	ETF	380.19	380.38	380.14	380.29	6906.0
2021-01-08 05:30:00	SPY	ETF	380.31	380.45	379.96	380.08	8591.0
2021-01-08 06:00:00	SPY	ETF	380.05	380.59	379.9	380.58	15733.0
2021-01-08 06:30:00	SPY	ETF	380.47	380.5	380.18	380.18	9985.0
2021-01-08 07:00:00	SPY	ETF	380.16	380.59	380.1	380.38	64749.0
2021-01-08 07:30:00	SPY	ETF	380.37	380.44	380.19	380.22	45204.0
2021-01-08 08:00:00	SPY	ETF	380.22	380.9	380.08	380.2	91661.0
2021-01-08 08:30:00	SPY	ETF	380.15	380.7699	379.7	380.05	478168.0
2021-01-08 09:00:00	SPY	ETF	380.09	380.75	380.07	380.58	165796.0
2021-01-08 09:30:00	SPY	ETF	380.59	381.215	380.05	380.51	5459795.0
2021-01-08 10:00:00	SPY	ETF	380.54	381.04	378.84	378.92	4348058.0
2021-01-08 10:30:00	SPY	ETF	378.91	380.76	378.895	380.55	3673285.0
2021-01-08 11:00:00	SPY	ETF	380.55	380.84	379.57	379.99	3554590.0
2021-01-08 11:30:00	SPY	ETF	379.98	380.24	379.55	380.24	2899483.0
2021-01-08 12:00:00	SPY	ETF	380.24	380.67	379.6021	380.38	2315500.0
2021-01-08 12:30:00	SPY	ETF	380.38	380.49	379.59	379.77	1195885.0
2021-01-08 13:00:00	SPY	ETF	379.75	379.9	377.8001	378.665	4104636.0
2021-01-08 13:30:00	SPY	ETF	378.67	378.72	377.1	378.24	5168139.0
2021-01-08 14:00:00	SPY	ETF	378.24	379.52	378.17	379.52	4899027.0
2021-01-08 14:30:00	SPY	ETF	379.51	380.08	378.825	379.99	4629257.0
2021-01-08 15:00:00	SPY	ETF	379.99	380.6625	379.94	380.475	5157189.0
2021-01-08 15:30:00	SPY	ETF	380.48	381.49	380.225	381.24	12716590.0
2021-01-08 16:00:00	SPY	ETF	381.24	381.83	381.2035	381.65	7174040.0
2021-01-08 16:30:00	SPY	ETF	381.67	381.96	381.55	381.7	299247.0
2021-01-08 17:00:00	SPY	ETF	381.75	381.91	381.68	381.82	73771.0
2021-01-08 17:30:00	SPY	ETF	381.82	381.85	381.71	381.71	34825.0
2021-01-08 18:00:00	SPY	ETF	381.68	381.88	381.68	381.88	12147.0
2021-01-08 18:30:00	SPY	ETF	381.91	381.95	381.6	381.6	16973.0
2021-01-08 19:00:00	SPY	ETF	381.8	381.8	381.66	381.75	5484.0
2021-01-08 19:30:00	SPY	ETF	381.65	381.75	381.6	381.6	18651.0
2021-01-08 04:00:00	QQQ	ETF	316.11	316.25	315.69	315.7	33526.0
2021-01-08 04:30:00	QQQ	ETF	315.73	316.33	315.72	316.22	14386.0
2021-01-08 05:00:00	QQQ	ETF	316.4	316.43	316.27	316.3	10582.0
2021-01-08 05:30:00	QQQ	ETF	316.35	316.37	316.15	316.25	18190.0
2021-01-08 06:00:00	QQQ	ETF	316.22	316.63	316.15	316.63	30071.0
2021-01-08 06:30:00	QQQ	ETF	316.57	316.6	316.3	316.36	14899.0
2021-01-08 07:00:00	QQQ	ETF	316.32	316.89	316.29	316.78	117171.0
2021-01-08 07:30:00	QQQ	ETF	316.84	316.96	316.64	316.71	84313.0
2021-01-08 08:00:00	QQQ	ETF	316.7	316.96	315.95	316.71	133011.0
2021-01-08 08:30:00	QQQ	ETF	316.45	317.19	316.44	316.7504	151412.0
2021-01-08 09:00:00	QQQ	ETF	316.8	317.4	316.76	317.4	238869.0
2021-01-08 09:30:00	QQQ	ETF	317.34	318.12	316.53	317.27	4202227.0
2021-01-08 10:00:00	QQQ	ETF	317.35	318.19	315.73	315.84	2284966.0
2021-01-08 10:30:00	QQQ	ETF	315.86	317.95	315.78	317.63	1916251.0
2021-01-08 11:00:00	QQQ	ETF	317.68	318.27	316.89	317.55	1694352.0
2021-01-08 11:30:00	QQQ	ETF	317.55	317.69	316.85	317.66	875528.0
2021-01-08 12:00:00	QQQ	ETF	317.69	318.45	317.08	317.98	978134.0
2021-01-08 12:30:00	QQQ	ETF	317.99	318.34	317.48	317.66	808484.0

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

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