PREVIEW / etf_30min / 2022-06-29

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-06-29.parquet
  size:    646 KB
  rows:    26,020

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
2022-06-29 04:00:00	SPY	ETF	380.71	381.45	380.31	380.98	24494.0
2022-06-29 04:30:00	SPY	ETF	381.04	381.44	380.83	381.15	6998.0
2022-06-29 05:00:00	SPY	ETF	381.07	381.3	381.0	381.02	13419.0
2022-06-29 05:30:00	SPY	ETF	380.93	380.93	379.45	379.45	25178.0
2022-06-29 06:00:00	SPY	ETF	379.56	380.42	379.56	379.92	23361.0
2022-06-29 06:30:00	SPY	ETF	379.89	380.12	379.63	379.91	23299.0
2022-06-29 07:00:00	SPY	ETF	379.92	380.04	379.51	379.96	65004.0
2022-06-29 07:30:00	SPY	ETF	379.96	381.53	379.96	381.4	158227.0
2022-06-29 08:00:00	SPY	ETF	381.39	382.24	379.49	381.4	467131.0
2022-06-29 08:30:00	SPY	ETF	381.44	381.58	380.34	380.8	212246.0
2022-06-29 09:00:00	SPY	ETF	380.71	381.94	380.7	381.25	533728.0
2022-06-29 09:30:00	SPY	ETF	381.23	381.91	378.42	381.0718	7160971.0
2022-06-29 10:00:00	SPY	ETF	381.04	382.27	379.66	381.12	5445026.0
2022-06-29 10:30:00	SPY	ETF	381.12	382.2	380.1105	380.84	4269830.0
2022-06-29 11:00:00	SPY	ETF	380.84	381.06	379.18	379.9301	3196936.0
2022-06-29 11:30:00	SPY	ETF	379.97	381.145	379.65	380.53	2863075.0
2022-06-29 12:00:00	SPY	ETF	380.51	380.7	378.45	378.59	2770838.0
2022-06-29 12:30:00	SPY	ETF	378.6	379.91	378.54	379.5783	2511430.0
2022-06-29 13:00:00	SPY	ETF	379.58	380.41	378.75	379.5789	2839307.0
2022-06-29 13:30:00	SPY	ETF	379.59	380.91	379.15	380.8207	2292878.0
2022-06-29 14:00:00	SPY	ETF	380.8177	381.7099	380.66	381.31	2981480.0
2022-06-29 14:30:00	SPY	ETF	381.31	381.35	379.68	380.07	2236486.0
2022-06-29 15:00:00	SPY	ETF	380.07	381.515	379.532	381.46	3635286.0
2022-06-29 15:30:00	SPY	ETF	381.49	381.505	379.53	380.36	7674354.0
2022-06-29 16:00:00	SPY	ETF	380.37	380.72	380.08	380.35	2635420.0
2022-06-29 16:30:00	SPY	ETF	380.42	380.62	380.42	380.6	122557.0
2022-06-29 17:00:00	SPY	ETF	380.55	380.65	380.5	380.54	31865.0
2022-06-29 17:30:00	SPY	ETF	380.5	380.59	380.5	380.53	4729.0
2022-06-29 18:00:00	SPY	ETF	380.6	380.67	380.33	380.6399	115942.0
2022-06-29 18:30:00	SPY	ETF	380.65	380.65	380.43	380.46	12926.0
2022-06-29 19:00:00	SPY	ETF	380.42	380.44	379.95	380.01	32576.0
2022-06-29 19:30:00	SPY	ETF	379.87	380.18	379.83	380.04	32719.0
2022-06-29 04:00:00	QQQ	ETF	283.36	284.18	283.27	283.64	70747.0
2022-06-29 04:30:00	QQQ	ETF	283.78	284.01	283.5	283.67	52427.0
2022-06-29 05:00:00	QQQ	ETF	283.65	284.05	283.6	283.68	11223.0
2022-06-29 05:30:00	QQQ	ETF	283.51	283.51	282.11	282.11	73826.0
2022-06-29 06:00:00	QQQ	ETF	282.33	282.96	282.33	282.5	59433.0
2022-06-29 06:30:00	QQQ	ETF	282.5	282.78	282.23	282.65	29412.0
2022-06-29 07:00:00	QQQ	ETF	282.56	282.7	282.24	282.62	116387.0
2022-06-29 07:30:00	QQQ	ETF	282.65	283.95	282.62	283.83	232526.0
2022-06-29 08:00:00	QQQ	ETF	282.66	284.65	282.1504	283.7	723260.0
2022-06-29 08:30:00	QQQ	ETF	283.88	283.88	282.66	283.17	479425.0
2022-06-29 09:00:00	QQQ	ETF	283.1	283.96	283.02	283.35	402418.0
2022-06-29 09:30:00	QQQ	ETF	283.4	284.7	280.84	283.9	8014778.0
2022-06-29 10:00:00	QQQ	ETF	283.85	285.27	282.464	283.9027	5489260.0
2022-06-29 10:30:00	QQQ	ETF	283.91	285.34	282.8502	283.93	3585329.0
2022-06-29 11:00:00	QQQ	ETF	283.95	284.16	282.635	283.5199	2682501.0
2022-06-29 11:30:00	QQQ	ETF	283.53	284.5491	283.15	283.97	2204948.0
2022-06-29 12:00:00	QQQ	ETF	283.9443	284.0597	281.82	281.93	1929062.0
2022-06-29 12:30:00	QQQ	ETF	281.95	283.13	281.865	282.97	1960498.0

> showing 50 of 26,020 rows — these rows as CSV

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