PREVIEW / etf_30min / 2021-08-27

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-08-27.parquet
  size:    611 KB
  rows:    22,771

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-08-27 04:00:00	SPY	ETF	447.6	447.82	447.5	447.56	19591.0
2021-08-27 04:30:00	SPY	ETF	447.53	447.68	447.53	447.66	1793.0
2021-08-27 05:00:00	SPY	ETF	447.54	447.81	447.5	447.78	9300.0
2021-08-27 05:30:00	SPY	ETF	447.75	447.83	447.72	447.82	9332.0
2021-08-27 06:00:00	SPY	ETF	447.74	447.83	447.64	447.66	15027.0
2021-08-27 06:30:00	SPY	ETF	447.61	447.76	447.54	447.68	42195.0
2021-08-27 07:00:00	SPY	ETF	447.62	447.68	447.4	447.55	70352.0
2021-08-27 07:30:00	SPY	ETF	447.55	447.57	447.05	447.31	153734.0
2021-08-27 08:00:00	SPY	ETF	447.5899	447.65	446.594	447.35	132934.0
2021-08-27 08:30:00	SPY	ETF	447.36	447.71	447.36	447.57	149906.0
2021-08-27 09:00:00	SPY	ETF	447.57	447.61	447.1	447.1	135839.0
2021-08-27 09:30:00	SPY	ETF	447.12	448.0196	447.06	447.79	4657074.0
2021-08-27 10:00:00	SPY	ETF	447.79	449.855	447.11	449.3	9069815.0
2021-08-27 10:30:00	SPY	ETF	449.31	449.86	448.88	449.63	3241980.0
2021-08-27 11:00:00	SPY	ETF	449.64	449.83	449.235	449.25	2539280.0
2021-08-27 11:30:00	SPY	ETF	449.25	449.98	449.25	449.88	1739441.0
2021-08-27 12:00:00	SPY	ETF	449.89	450.02	449.68	449.9499	1787206.0
2021-08-27 12:30:00	SPY	ETF	449.95	450.185	449.9	450.18	1671518.0
2021-08-27 13:00:00	SPY	ETF	450.175	450.43	450.13	450.33	1958779.0
2021-08-27 13:30:00	SPY	ETF	450.33	450.46	450.22	450.35	1877441.0
2021-08-27 14:00:00	SPY	ETF	450.35	450.355	449.99	450.2	1995845.0
2021-08-27 14:30:00	SPY	ETF	450.18	450.33	450.11	450.18	1519455.0
2021-08-27 15:00:00	SPY	ETF	450.18	450.56	450.18	450.33	2407097.0
2021-08-27 15:30:00	SPY	ETF	450.33	450.65	450.02	450.18	11793035.0
2021-08-27 16:00:00	SPY	ETF	450.19	450.32	450.0	450.22	3895982.0
2021-08-27 16:30:00	SPY	ETF	450.22	450.44	450.22	450.41	1346902.0
2021-08-27 17:00:00	SPY	ETF	450.38	450.38	450.26	450.26	8584.0
2021-08-27 17:30:00	SPY	ETF	450.26	450.39	450.17	450.28	35174.0
2021-08-27 18:00:00	SPY	ETF	450.28	450.41	450.28	450.39	21191.0
2021-08-27 18:30:00	SPY	ETF	450.25	450.4	450.25	450.38	1902.0
2021-08-27 19:00:00	SPY	ETF	450.38	450.44	450.37	450.44	8009.0
2021-08-27 19:30:00	SPY	ETF	450.4	450.46	450.37	450.39	11114.0
2021-08-27 04:00:00	QQQ	ETF	373.05	373.75	373.05	373.37	16067.0
2021-08-27 04:30:00	QQQ	ETF	373.38	373.65	373.38	373.65	2346.0
2021-08-27 05:00:00	QQQ	ETF	373.58	373.73	373.47	373.63	9984.0
2021-08-27 05:30:00	QQQ	ETF	373.6	373.72	373.6	373.71	3498.0
2021-08-27 06:00:00	QQQ	ETF	373.69	373.75	373.61	373.69	8963.0
2021-08-27 06:30:00	QQQ	ETF	373.62	373.8	373.6	373.69	2335.0
2021-08-27 07:00:00	QQQ	ETF	373.69	373.73	373.46	373.58	26925.0
2021-08-27 07:30:00	QQQ	ETF	373.6	373.61	373.28	373.42	21663.0
2021-08-27 08:00:00	QQQ	ETF	373.7496	373.83	372.699	373.41	42457.0
2021-08-27 08:30:00	QQQ	ETF	373.45	373.82	373.45	373.72	63724.0
2021-08-27 09:00:00	QQQ	ETF	373.73	373.73	373.01	373.04	134471.0
2021-08-27 09:30:00	QQQ	ETF	373.07	373.8289	372.66	373.21	2781076.0
2021-08-27 10:00:00	QQQ	ETF	373.22	376.15	372.57	375.19	5244307.0
2021-08-27 10:30:00	QQQ	ETF	375.2	375.9026	374.47	375.42	1966718.0
2021-08-27 11:00:00	QQQ	ETF	375.44	375.69	375.005	375.0313	1032562.0
2021-08-27 11:30:00	QQQ	ETF	375.04	375.89	375.011	375.7999	1080758.0
2021-08-27 12:00:00	QQQ	ETF	375.805	375.97	375.5405	375.62	751919.0
2021-08-27 12:30:00	QQQ	ETF	375.63	375.87	375.58	375.86	480201.0

> showing 50 of 22,771 rows — these rows as CSV

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