PREVIEW / etf_30min / 2021-06-03

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-06-03.parquet
  size:    599 KB
  rows:    23,311

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-06-03 04:00:00	SPY	ETF	419.63	419.76	419.49	419.76	11262.0
2021-06-03 04:30:00	SPY	ETF	419.87	420.02	419.86	419.98	2126.0
2021-06-03 05:00:00	SPY	ETF	419.9	419.9	419.35	419.36	6340.0
2021-06-03 05:30:00	SPY	ETF	419.39	419.64	419.37	419.52	7076.0
2021-06-03 06:00:00	SPY	ETF	419.51	419.51	418.77	419.0	28422.0
2021-06-03 06:30:00	SPY	ETF	419.05	419.08	417.83	418.02	111618.0
2021-06-03 07:00:00	SPY	ETF	418.05	418.1	417.33	417.76	252027.0
2021-06-03 07:30:00	SPY	ETF	417.66	417.84	416.97	417.34	199378.0
2021-06-03 08:00:00	SPY	ETF	417.3	420.98	416.76	417.42	376413.0
2021-06-03 08:30:00	SPY	ETF	417.45	418.07	417.31	417.61	383725.0
2021-06-03 09:00:00	SPY	ETF	417.71	418.1899	417.69	417.78	172810.0
2021-06-03 09:30:00	SPY	ETF	417.87	418.24	416.28	417.17	7164722.0
2021-06-03 10:00:00	SPY	ETF	417.16	418.17	417.03	417.64	4605429.0
2021-06-03 10:30:00	SPY	ETF	417.63	419.3511	417.26	419.325	4752081.0
2021-06-03 11:00:00	SPY	ETF	419.33	419.99	419.155	419.67	4897804.0
2021-06-03 11:30:00	SPY	ETF	419.67	419.78	419.07	419.425	2108428.0
2021-06-03 12:00:00	SPY	ETF	419.43	419.65	418.93	419.325	2226658.0
2021-06-03 12:30:00	SPY	ETF	419.327	419.75	419.13	419.56	1989897.0
2021-06-03 13:00:00	SPY	ETF	419.5704	419.86	418.88	419.805	2178711.0
2021-06-03 13:30:00	SPY	ETF	419.8	419.9	419.37	419.5301	1893901.0
2021-06-03 14:00:00	SPY	ETF	419.53	419.61	419.01	419.05	1612756.0
2021-06-03 14:30:00	SPY	ETF	419.04	419.29	418.74	418.765	2033161.0
2021-06-03 15:00:00	SPY	ETF	418.76	419.18	418.74	419.17	2136280.0
2021-06-03 15:30:00	SPY	ETF	419.18	419.45	418.73	418.82	5772876.0
2021-06-03 16:00:00	SPY	ETF	418.81	418.91	418.6	418.62	2000414.0
2021-06-03 16:30:00	SPY	ETF	418.64	418.88	418.64	418.87	93438.0
2021-06-03 17:00:00	SPY	ETF	418.77	418.97	418.76	418.77	25342.0
2021-06-03 17:30:00	SPY	ETF	418.83	418.99	418.83	418.84	19244.0
2021-06-03 18:00:00	SPY	ETF	418.89	419.12	418.77	418.79	34752.0
2021-06-03 18:30:00	SPY	ETF	418.77	418.83	418.61	418.83	17522.0
2021-06-03 19:00:00	SPY	ETF	418.9	418.9	418.5	418.62	13552.0
2021-06-03 19:30:00	SPY	ETF	418.55	418.55	418.31	418.37	13981.0
2021-06-03 04:00:00	QQQ	ETF	333.02	333.13	332.86	333.04	11382.0
2021-06-03 04:30:00	QQQ	ETF	333.07	333.27	333.07	333.23	3334.0
2021-06-03 05:00:00	QQQ	ETF	333.25	333.25	332.46	332.5	7079.0
2021-06-03 05:30:00	QQQ	ETF	332.5	332.7	332.43	332.67	6745.0
2021-06-03 06:00:00	QQQ	ETF	332.62	332.65	332.11	332.27	29781.0
2021-06-03 06:30:00	QQQ	ETF	332.27	332.27	330.88	331.06	72897.0
2021-06-03 07:00:00	QQQ	ETF	331.1	331.19	330.11	330.54	225435.0
2021-06-03 07:30:00	QQQ	ETF	330.54	330.75	329.69	330.07	377935.0
2021-06-03 08:00:00	QQQ	ETF	329.95	333.63	329.49	329.96	289269.0
2021-06-03 08:30:00	QQQ	ETF	329.97	330.68	329.79	330.291	236041.0
2021-06-03 09:00:00	QQQ	ETF	330.32	330.75	330.32	330.54	137035.0
2021-06-03 09:30:00	QQQ	ETF	330.55	330.8999	328.28	329.18	5553607.0
2021-06-03 10:00:00	QQQ	ETF	329.18	330.43	328.97	329.59	3010668.0
2021-06-03 10:30:00	QQQ	ETF	329.59	331.14	328.75	331.14	2870577.0
2021-06-03 11:00:00	QQQ	ETF	331.14	331.86	330.58	330.87	2874835.0
2021-06-03 11:30:00	QQQ	ETF	330.87	331.02	329.89	330.4596	1805410.0
2021-06-03 12:00:00	QQQ	ETF	330.46	330.89	330.02	330.53	1740888.0
2021-06-03 12:30:00	QQQ	ETF	330.53	331.155	330.24	331.14	1137818.0

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

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