PREVIEW / etf_30min / 2022-08-04

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-08-04.parquet
  size:    643 KB
  rows:    25,605

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-04 04:00:00	SPY	ETF	414.45	414.5	414.0	414.26	10185.0
2022-08-04 04:30:00	SPY	ETF	414.19	414.2	413.99	413.99	10768.0
2022-08-04 05:00:00	SPY	ETF	414.08	414.75	414.04	414.74	10632.0
2022-08-04 05:30:00	SPY	ETF	414.86	415.15	414.67	414.95	19098.0
2022-08-04 06:00:00	SPY	ETF	414.96	415.72	414.95	415.61	20312.0
2022-08-04 06:30:00	SPY	ETF	415.59	416.1	415.5	415.55	81235.0
2022-08-04 07:00:00	SPY	ETF	415.46	415.62	414.91	414.94	96267.0
2022-08-04 07:30:00	SPY	ETF	414.93	415.25	414.44	414.44	65203.0
2022-08-04 08:00:00	SPY	ETF	415.2308	416.0204	413.7849	414.8	367249.0
2022-08-04 08:30:00	SPY	ETF	414.74	415.44	414.62	415.28	176502.0
2022-08-04 09:00:00	SPY	ETF	415.24	415.24	414.01	414.3	194916.0
2022-08-04 09:30:00	SPY	ETF	414.36	415.05	413.43	414.48	4878787.0
2022-08-04 10:00:00	SPY	ETF	414.48	415.09	413.23	413.48	3006785.0
2022-08-04 10:30:00	SPY	ETF	413.48	414.25	412.44	413.99	3057359.0
2022-08-04 11:00:00	SPY	ETF	414.0	414.29	412.97	413.35	2076152.0
2022-08-04 11:30:00	SPY	ETF	413.36	414.44	412.7558	414.3	1685828.0
2022-08-04 12:00:00	SPY	ETF	414.31	414.64	413.86	414.595	1433695.0
2022-08-04 12:30:00	SPY	ETF	414.6	414.6	413.054	413.2	1317957.0
2022-08-04 13:00:00	SPY	ETF	413.17	414.47	413.1449	414.29	1519880.0
2022-08-04 13:30:00	SPY	ETF	414.28	414.665	413.9001	414.18	1252757.0
2022-08-04 14:00:00	SPY	ETF	414.1899	414.39	413.5903	414.18	1524043.0
2022-08-04 14:30:00	SPY	ETF	414.22	414.51	413.61	414.21	1631000.0
2022-08-04 15:00:00	SPY	ETF	414.24	415.0	413.99	414.63	2161645.0
2022-08-04 15:30:00	SPY	ETF	414.6399	414.64	413.59	414.17	4732875.0
2022-08-04 16:00:00	SPY	ETF	414.17	414.59	413.92	414.0	1861134.0
2022-08-04 16:30:00	SPY	ETF	414.04	414.19	413.99	414.05	105841.0
2022-08-04 17:00:00	SPY	ETF	414.08	414.19	414.08	414.13	11486.0
2022-08-04 17:30:00	SPY	ETF	414.1	414.25	414.1	414.11	36811.0
2022-08-04 18:00:00	SPY	ETF	414.1	414.17	413.88	414.05	43535.0
2022-08-04 18:30:00	SPY	ETF	414.09	414.26	414.09	414.18	21246.0
2022-08-04 19:00:00	SPY	ETF	414.2	414.51	414.2	414.33	14165.0
2022-08-04 19:30:00	SPY	ETF	414.36	414.5	414.22	414.23	80669.0
2022-08-04 04:00:00	QQQ	ETF	322.11	322.87	322.11	322.7	50673.0
2022-08-04 04:30:00	QQQ	ETF	322.74	322.74	322.41	322.52	11815.0
2022-08-04 05:00:00	QQQ	ETF	322.54	323.29	322.29	323.26	32842.0
2022-08-04 05:30:00	QQQ	ETF	323.29	323.49	322.87	323.43	38306.0
2022-08-04 06:00:00	QQQ	ETF	323.58	324.47	323.58	324.45	58228.0
2022-08-04 06:30:00	QQQ	ETF	324.4	324.9	324.33	324.54	72350.0
2022-08-04 07:00:00	QQQ	ETF	324.36	324.5	323.48	323.55	262575.0
2022-08-04 07:30:00	QQQ	ETF	323.57	323.96	322.86	322.9	207714.0
2022-08-04 08:00:00	QQQ	ETF	323.87	324.68	322.01	323.37	270278.0
2022-08-04 08:30:00	QQQ	ETF	323.4	324.12	323.14	323.98	268804.0
2022-08-04 09:00:00	QQQ	ETF	323.94	323.95	322.73	322.92	391933.0
2022-08-04 09:30:00	QQQ	ETF	322.92	324.52	322.21	323.7	5331637.0
2022-08-04 10:00:00	QQQ	ETF	323.74	324.37	321.9119	322.13	2799552.0
2022-08-04 10:30:00	QQQ	ETF	322.14	322.71	320.77	322.48	3193888.0
2022-08-04 11:00:00	QQQ	ETF	322.47	322.79	321.11	321.7	2318350.0
2022-08-04 11:30:00	QQQ	ETF	321.7	323.359	321.23	323.19	1763028.0
2022-08-04 12:00:00	QQQ	ETF	323.21	323.9261	322.77	323.81	1577990.0
2022-08-04 12:30:00	QQQ	ETF	323.8101	323.8119	322.21	322.3302	1421858.0

> showing 50 of 25,605 rows — these rows as CSV

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