PREVIEW / etf_30min / 2022-08-22

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-08-22.parquet
  size:    672 KB
  rows:    26,729

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-22 04:00:00	SPY	ETF	419.97	419.97	417.31	417.7	40504.0
2022-08-22 04:30:00	SPY	ETF	417.68	417.75	417.1	417.58	12006.0
2022-08-22 05:00:00	SPY	ETF	417.42	417.7	417.26	417.31	15999.0
2022-08-22 05:30:00	SPY	ETF	417.33	417.46	416.77	417.35	25663.0
2022-08-22 06:00:00	SPY	ETF	417.31	417.85	417.29	417.62	34147.0
2022-08-22 06:30:00	SPY	ETF	417.58	417.86	417.4	417.66	25835.0
2022-08-22 07:00:00	SPY	ETF	417.68	418.04	417.48	417.55	103768.0
2022-08-22 07:30:00	SPY	ETF	417.52	417.72	417.31	417.65	205003.0
2022-08-22 08:00:00	SPY	ETF	417.8	421.13	416.8396	417.22	355976.0
2022-08-22 08:30:00	SPY	ETF	417.27	417.52	417.09	417.09	145572.0
2022-08-22 09:00:00	SPY	ETF	417.08	417.41	417.0	417.05	245587.0
2022-08-22 09:30:00	SPY	ETF	417.05	417.23	415.63	416.19	6265898.0
2022-08-22 10:00:00	SPY	ETF	416.21	416.46	414.68	414.8993	4159886.0
2022-08-22 10:30:00	SPY	ETF	414.9	415.4771	414.36	414.38	3817172.0
2022-08-22 11:00:00	SPY	ETF	414.385	415.37	414.341	414.99	2672965.0
2022-08-22 11:30:00	SPY	ETF	414.98	415.75	414.81	415.45	2147993.0
2022-08-22 12:00:00	SPY	ETF	415.46	415.75	414.92	415.1362	1865322.0
2022-08-22 12:30:00	SPY	ETF	415.12	415.57	414.69	415.1699	1484883.0
2022-08-22 13:00:00	SPY	ETF	415.15	415.22	414.08	414.13	2104483.0
2022-08-22 13:30:00	SPY	ETF	414.12	414.155	413.2782	413.3692	2969477.0
2022-08-22 14:00:00	SPY	ETF	413.37	413.59	413.1	413.31	2759075.0
2022-08-22 14:30:00	SPY	ETF	413.29	413.4	412.54	412.87	2624587.0
2022-08-22 15:00:00	SPY	ETF	412.87	413.76	412.86	413.15	4044382.0
2022-08-22 15:30:00	SPY	ETF	413.155	413.58	412.4	413.46	11155763.0
2022-08-22 16:00:00	SPY	ETF	413.45	413.85	413.2193	413.81	3533255.0
2022-08-22 16:30:00	SPY	ETF	413.82	413.88	413.77	413.86	207639.0
2022-08-22 17:00:00	SPY	ETF	413.65	413.89	413.65	413.89	24707.0
2022-08-22 17:30:00	SPY	ETF	413.8209	413.91	413.8209	413.9	10508.0
2022-08-22 18:00:00	SPY	ETF	413.9	413.92	413.59	413.89	32470.0
2022-08-22 18:30:00	SPY	ETF	413.85	414.19	413.85	414.06	24930.0
2022-08-22 19:00:00	SPY	ETF	414.06	414.28	414.01	414.08	23541.0
2022-08-22 19:30:00	SPY	ETF	414.04	414.48	414.04	414.39	39424.0
2022-08-22 04:00:00	QQQ	ETF	320.8	321.6	318.22	318.48	90641.0
2022-08-22 04:30:00	QQQ	ETF	318.29	318.35	317.9	318.22	34008.0
2022-08-22 05:00:00	QQQ	ETF	318.09	318.35	317.86	318.09	27771.0
2022-08-22 05:30:00	QQQ	ETF	318.05	318.3	317.68	318.2	23668.0
2022-08-22 06:00:00	QQQ	ETF	318.19	318.76	318.19	318.49	32846.0
2022-08-22 06:30:00	QQQ	ETF	318.41	318.53	318.14	318.39	22842.0
2022-08-22 07:00:00	QQQ	ETF	318.39	318.67	318.06	318.16	166914.0
2022-08-22 07:30:00	QQQ	ETF	318.1	318.33	317.85	318.27	140598.0
2022-08-22 08:00:00	QQQ	ETF	318.2501	323.102	317.79	318.03	241650.0
2022-08-22 08:30:00	QQQ	ETF	318.07	318.34	317.98	318.08	271897.0
2022-08-22 09:00:00	QQQ	ETF	318.1	318.55	318.0	318.47	357695.0
2022-08-22 09:30:00	QQQ	ETF	318.5	318.74	316.7	317.23	5936219.0
2022-08-22 10:00:00	QQQ	ETF	317.23	317.3	315.67	316.055	3256557.0
2022-08-22 10:30:00	QQQ	ETF	316.05	316.7	315.35	315.36	2686743.0
2022-08-22 11:00:00	QQQ	ETF	315.37	316.01	315.22	315.46	2466828.0
2022-08-22 11:30:00	QQQ	ETF	315.4501	316.52	315.2501	316.3001	1977035.0
2022-08-22 12:00:00	QQQ	ETF	316.33	316.55	315.78	316.0199	1217297.0
2022-08-22 12:30:00	QQQ	ETF	316.0	316.37	315.58	316.0	993323.0

> showing 50 of 26,729 rows — these rows as CSV

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