PREVIEW / etf_30min / 2021-10-07

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-10-07.parquet
  size:    627 KB
  rows:    24,047

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-10-07 04:00:00	SPY	ETF	437.01	437.57	436.99	437.05	49713.0
2021-10-07 04:30:00	SPY	ETF	437.27	437.94	437.24	437.6	28476.0
2021-10-07 05:00:00	SPY	ETF	437.49	437.61	437.32	437.34	6029.0
2021-10-07 05:30:00	SPY	ETF	437.37	437.66	437.37	437.66	2525.0
2021-10-07 06:00:00	SPY	ETF	437.73	438.06	437.7	437.72	14943.0
2021-10-07 06:30:00	SPY	ETF	437.7	438.59	437.65	438.59	139074.0
2021-10-07 07:00:00	SPY	ETF	438.55	439.2	438.43	439.1	168731.0
2021-10-07 07:30:00	SPY	ETF	439.09	439.3	438.86	438.9	258207.0
2021-10-07 08:00:00	SPY	ETF	438.6201	439.27	436.55	439.09	271985.0
2021-10-07 08:30:00	SPY	ETF	438.91	439.37	438.72	439.0	348753.0
2021-10-07 09:00:00	SPY	ETF	439.02	439.04	438.12	438.41	457656.0
2021-10-07 09:30:00	SPY	ETF	438.39	440.6771	438.24	440.67	9659249.0
2021-10-07 10:00:00	SPY	ETF	440.67	441.68	440.52	441.41	7590151.0
2021-10-07 10:30:00	SPY	ETF	441.41	441.6	440.83	441.34	4035313.0
2021-10-07 11:00:00	SPY	ETF	441.345	441.41	440.46	440.85	3017983.0
2021-10-07 11:30:00	SPY	ETF	440.87	441.41	440.78	441.375	2286990.0
2021-10-07 12:00:00	SPY	ETF	441.39	441.55	440.7601	441.0	2179262.0
2021-10-07 12:30:00	SPY	ETF	441.0	441.31	440.7	441.16	1888817.0
2021-10-07 13:00:00	SPY	ETF	441.16	441.21	440.75	441.205	1563532.0
2021-10-07 13:30:00	SPY	ETF	441.2	441.22	440.48	440.5673	1984429.0
2021-10-07 14:00:00	SPY	ETF	440.56	440.62	439.84	439.9501	3174166.0
2021-10-07 14:30:00	SPY	ETF	439.96	440.085	439.02	439.15	3173226.0
2021-10-07 15:00:00	SPY	ETF	439.14	440.0	438.88	439.6099	4253628.0
2021-10-07 15:30:00	SPY	ETF	439.59	439.72	438.2	438.64	8943674.0
2021-10-07 16:00:00	SPY	ETF	438.63	438.95	438.56	438.89	2795885.0
2021-10-07 16:30:00	SPY	ETF	438.83	439.02	438.46	438.58	205872.0
2021-10-07 17:00:00	SPY	ETF	438.73	438.76	438.62	438.7	49737.0
2021-10-07 17:30:00	SPY	ETF	438.71	438.75	438.63	438.67	133259.0
2021-10-07 18:00:00	SPY	ETF	438.66	439.0	438.6	438.82	42114.0
2021-10-07 18:30:00	SPY	ETF	438.66	439.14	438.66	439.14	26749.0
2021-10-07 19:00:00	SPY	ETF	439.18	439.33	439.0	439.2	17419.0
2021-10-07 19:30:00	SPY	ETF	439.15	439.65	439.03	439.58	32530.0
2021-10-07 04:00:00	QQQ	ETF	363.09	363.27	362.76	362.81	41213.0
2021-10-07 04:30:00	QQQ	ETF	363.02	363.48	363.02	363.23	72776.0
2021-10-07 05:00:00	QQQ	ETF	363.22	363.33	362.96	363.05	15527.0
2021-10-07 05:30:00	QQQ	ETF	362.97	363.14	362.85	362.95	18720.0
2021-10-07 06:00:00	QQQ	ETF	363.14	363.32	362.89	362.89	20194.0
2021-10-07 06:30:00	QQQ	ETF	362.85	363.55	362.85	363.52	41185.0
2021-10-07 07:00:00	QQQ	ETF	363.51	364.17	363.44	364.1	219046.0
2021-10-07 07:30:00	QQQ	ETF	364.15	364.44	364.0	364.16	142659.0
2021-10-07 08:00:00	QQQ	ETF	363.7601	364.43	359.67	363.82	268279.0
2021-10-07 08:30:00	QQQ	ETF	363.82	364.03	363.51	363.59	205935.0
2021-10-07 09:00:00	QQQ	ETF	363.56	363.6	362.5	362.83	530706.0
2021-10-07 09:30:00	QQQ	ETF	362.8	364.62	362.25	364.6	5839453.0
2021-10-07 10:00:00	QQQ	ETF	364.61	365.56	364.4	365.22	3552942.0
2021-10-07 10:30:00	QQQ	ETF	365.24	365.65	365.02	365.23	2542370.0
2021-10-07 11:00:00	QQQ	ETF	365.24	365.36	364.57	364.87	1591288.0
2021-10-07 11:30:00	QQQ	ETF	364.88	365.66	364.8	365.635	1665468.0
2021-10-07 12:00:00	QQQ	ETF	365.64	365.69	364.88	365.05	1254098.0
2021-10-07 12:30:00	QQQ	ETF	365.07	365.3899	364.91	365.34	1173539.0

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

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