PREVIEW / etf_30min / 2021-07-27

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-07-27.parquet
  size:    613 KB
  rows:    23,436

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-07-27 04:00:00	SPY	ETF	439.38	439.8	438.72	438.72	34609.0
2021-07-27 04:30:00	SPY	ETF	438.77	439.32	438.77	439.3	10487.0
2021-07-27 05:00:00	SPY	ETF	439.25	439.25	438.8	439.23	20931.0
2021-07-27 05:30:00	SPY	ETF	439.17	439.7	439.17	439.55	21999.0
2021-07-27 06:00:00	SPY	ETF	439.59	439.74	439.54	439.67	11415.0
2021-07-27 06:30:00	SPY	ETF	439.78	440.05	439.73	440.05	8950.0
2021-07-27 07:00:00	SPY	ETF	440.09	440.54	440.09	440.39	55433.0
2021-07-27 07:30:00	SPY	ETF	440.44	440.71	440.12	440.18	69913.0
2021-07-27 08:00:00	SPY	ETF	440.32	440.5196	438.82	440.1	87363.0
2021-07-27 08:30:00	SPY	ETF	440.1	440.6	439.87	440.28	212955.0
2021-07-27 09:00:00	SPY	ETF	440.29	440.35	439.83	439.93	135230.0
2021-07-27 09:30:00	SPY	ETF	439.91	439.94	438.53	439.25	5978953.0
2021-07-27 10:00:00	SPY	ETF	439.25	439.64	438.05	439.1	4814541.0
2021-07-27 10:30:00	SPY	ETF	439.1	439.12	437.93	438.5617	4410156.0
2021-07-27 11:00:00	SPY	ETF	438.56	439.09	437.33	437.74	3738707.0
2021-07-27 11:30:00	SPY	ETF	437.74	437.87	436.76	437.61	4648811.0
2021-07-27 12:00:00	SPY	ETF	437.6	437.61	436.37	437.23	3492493.0
2021-07-27 12:30:00	SPY	ETF	437.23	437.3698	436.72	436.81	1953335.0
2021-07-27 13:00:00	SPY	ETF	436.795	437.2	436.015	436.3099	2405607.0
2021-07-27 13:30:00	SPY	ETF	436.31	436.93	435.99	436.339	2208434.0
2021-07-27 14:00:00	SPY	ETF	436.33	437.75	436.28	437.54	3349055.0
2021-07-27 14:30:00	SPY	ETF	437.53	438.06	437.4	438.025	2174026.0
2021-07-27 15:00:00	SPY	ETF	438.02	438.39	437.87	438.02	3089243.0
2021-07-27 15:30:00	SPY	ETF	438.02	439.06	437.69	438.99	8435409.0
2021-07-27 16:00:00	SPY	ETF	438.99	439.02	437.87	438.39	2676498.0
2021-07-27 16:30:00	SPY	ETF	438.42	439.01	437.73	437.77	331925.0
2021-07-27 17:00:00	SPY	ETF	437.72	437.99	437.11	437.25	73177.0
2021-07-27 17:30:00	SPY	ETF	437.3	437.61	437.15	437.41	27717.0
2021-07-27 18:00:00	SPY	ETF	437.45	438.14	437.45	438.14	55411.0
2021-07-27 18:30:00	SPY	ETF	439.01	439.01	438.14	438.44	11607.0
2021-07-27 19:00:00	SPY	ETF	438.44	438.64	438.27	438.63	20254.0
2021-07-27 19:30:00	SPY	ETF	438.67	438.74	438.5	438.74	20907.0
2021-07-27 04:00:00	QQQ	ETF	368.0	368.0	367.27	367.27	18212.0
2021-07-27 04:30:00	QQQ	ETF	367.28	367.7	367.27	367.59	10834.0
2021-07-27 05:00:00	QQQ	ETF	367.51	367.73	367.41	367.73	11023.0
2021-07-27 05:30:00	QQQ	ETF	367.72	368.12	367.71	368.03	10515.0
2021-07-27 06:00:00	QQQ	ETF	368.05	368.16	367.96	367.99	8998.0
2021-07-27 06:30:00	QQQ	ETF	368.07	368.28	368.07	368.28	7981.0
2021-07-27 07:00:00	QQQ	ETF	368.29	368.77	368.29	368.61	57977.0
2021-07-27 07:30:00	QQQ	ETF	368.64	368.82	368.4	368.51	37901.0
2021-07-27 08:00:00	QQQ	ETF	367.9804	368.8	367.13	368.46	53975.0
2021-07-27 08:30:00	QQQ	ETF	368.47	368.71	368.34	368.62	149962.0
2021-07-27 09:00:00	QQQ	ETF	368.57	368.57	368.07	368.23	73757.0
2021-07-27 09:30:00	QQQ	ETF	368.19	368.22	366.52	366.65	4111084.0
2021-07-27 10:00:00	QQQ	ETF	366.65	367.038	364.43	365.3	4814204.0
2021-07-27 10:30:00	QQQ	ETF	365.3	365.31	362.8675	363.52	4157517.0
2021-07-27 11:00:00	QQQ	ETF	363.47	364.08	361.98	362.5062	3595419.0
2021-07-27 11:30:00	QQQ	ETF	362.5	362.5	361.22	362.16	3778804.0
2021-07-27 12:00:00	QQQ	ETF	362.15	362.18	360.87	362.15	4007102.0
2021-07-27 12:30:00	QQQ	ETF	362.12	362.25	361.24	361.29	2225587.0

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

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