PREVIEW / etf_30min / 2022-08-09

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-08-09.parquet
  size:    633 KB
  rows:    24,889

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-08-09 04:00:00	SPY	ETF	413.51	413.7	413.14	413.58	3899.0
2022-08-09 04:30:00	SPY	ETF	413.67	413.8	413.5	413.65	2453.0
2022-08-09 05:00:00	SPY	ETF	413.65	413.91	413.59	413.59	6547.0
2022-08-09 05:30:00	SPY	ETF	413.47	413.65	413.42	413.52	5050.0
2022-08-09 06:00:00	SPY	ETF	413.28	413.28	412.24	412.31	38399.0
2022-08-09 06:30:00	SPY	ETF	412.31	412.42	412.0	412.23	20349.0
2022-08-09 07:00:00	SPY	ETF	412.36	412.66	412.02	412.15	56862.0
2022-08-09 07:30:00	SPY	ETF	412.1	412.39	411.41	411.59	90236.0
2022-08-09 08:00:00	SPY	ETF	412.0499	413.85	411.28	412.01	186171.0
2022-08-09 08:30:00	SPY	ETF	412.03	412.3	411.74	412.07	118750.0
2022-08-09 09:00:00	SPY	ETF	412.08	412.99	411.68	412.23	145075.0
2022-08-09 09:30:00	SPY	ETF	412.23	412.75	410.91	411.1353	4200147.0
2022-08-09 10:00:00	SPY	ETF	411.13	411.7699	410.73	411.684	2895547.0
2022-08-09 10:30:00	SPY	ETF	411.71	412.15	411.16	411.33	2360840.0
2022-08-09 11:00:00	SPY	ETF	411.34	412.33	410.36	411.92	2692757.0
2022-08-09 11:30:00	SPY	ETF	411.92	412.04	411.19	411.32	1977921.0
2022-08-09 12:00:00	SPY	ETF	411.32	411.58	410.5	410.5684	1812146.0
2022-08-09 12:30:00	SPY	ETF	410.55	410.94	410.45	410.8901	1416377.0
2022-08-09 13:00:00	SPY	ETF	410.9022	411.34	410.5601	411.2	2015782.0
2022-08-09 13:30:00	SPY	ETF	411.2	411.4999	410.3032	411.285	1815323.0
2022-08-09 14:00:00	SPY	ETF	411.286	411.55	410.23	410.31	2045353.0
2022-08-09 14:30:00	SPY	ETF	410.3	411.4299	410.22	411.04	2052150.0
2022-08-09 15:00:00	SPY	ETF	411.03	411.74	410.76	411.49	2405951.0
2022-08-09 15:30:00	SPY	ETF	411.49	411.63	410.79	411.34	5860555.0
2022-08-09 16:00:00	SPY	ETF	411.34	411.77	411.33	411.65	1864546.0
2022-08-09 16:30:00	SPY	ETF	411.67	411.82	411.55	411.82	179817.0
2022-08-09 17:00:00	SPY	ETF	411.84	412.0	411.77	411.77	63090.0
2022-08-09 17:30:00	SPY	ETF	411.77	411.8	411.68	411.7	29273.0
2022-08-09 18:00:00	SPY	ETF	411.73	411.78	411.51	411.71	43601.0
2022-08-09 18:30:00	SPY	ETF	411.61	411.68	411.55	411.6	4413.0
2022-08-09 19:00:00	SPY	ETF	411.56	411.8	411.55	411.64	18696.0
2022-08-09 19:30:00	SPY	ETF	411.63	411.8	411.53	411.79	44782.0
2022-08-09 04:00:00	QQQ	ETF	320.98	321.05	320.42	320.97	39617.0
2022-08-09 04:30:00	QQQ	ETF	321.1	321.11	320.92	321.07	3265.0
2022-08-09 05:00:00	QQQ	ETF	321.11	321.11	320.68	320.69	23547.0
2022-08-09 05:30:00	QQQ	ETF	320.62	320.79	320.27	320.37	31779.0
2022-08-09 06:00:00	QQQ	ETF	320.44	320.44	318.96	319.1	126353.0
2022-08-09 06:30:00	QQQ	ETF	319.05	319.19	318.78	319.14	64549.0
2022-08-09 07:00:00	QQQ	ETF	319.1	319.55	318.99	319.07	353829.0
2022-08-09 07:30:00	QQQ	ETF	319.03	319.4	318.34	318.5	214177.0
2022-08-09 08:00:00	QQQ	ETF	319.45	321.85	318.19	318.84	244758.0
2022-08-09 08:30:00	QQQ	ETF	318.82	319.11	318.6	318.8	147501.0
2022-08-09 09:00:00	QQQ	ETF	318.76	319.0	318.41	318.75	178458.0
2022-08-09 09:30:00	QQQ	ETF	318.77	319.03	316.1606	316.37	5360202.0
2022-08-09 10:00:00	QQQ	ETF	316.33	316.96	315.65	316.91	2698143.0
2022-08-09 10:30:00	QQQ	ETF	316.9415	317.81	316.5	316.95	1976388.0
2022-08-09 11:00:00	QQQ	ETF	317.0	317.94	315.91	317.45	2224558.0
2022-08-09 11:30:00	QQQ	ETF	317.46	317.68	316.54	316.58	1511625.0
2022-08-09 12:00:00	QQQ	ETF	316.58	316.77	315.42	315.5	1574336.0
2022-08-09 12:30:00	QQQ	ETF	315.5	316.06	315.45	315.9199	1320321.0

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

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