PREVIEW / etf_30min / 2021-05-14

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-05-14.parquet
  size:    611 KB
  rows:    23,385

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-05-14 04:00:00	SPY	ETF	412.13	412.64	412.0	412.5	14956.0
2021-05-14 04:30:00	SPY	ETF	412.69	412.99	412.67	412.83	13503.0
2021-05-14 05:00:00	SPY	ETF	412.92	413.42	412.87	413.19	16370.0
2021-05-14 05:30:00	SPY	ETF	413.08	413.2	412.8	412.8	8950.0
2021-05-14 06:00:00	SPY	ETF	412.97	413.0	412.73	412.88	6398.0
2021-05-14 06:30:00	SPY	ETF	412.95	413.02	412.67	412.79	73424.0
2021-05-14 07:00:00	SPY	ETF	412.76	413.2	412.63	413.15	92665.0
2021-05-14 07:30:00	SPY	ETF	413.19	413.4	413.0	413.14	265291.0
2021-05-14 08:00:00	SPY	ETF	412.86	413.37	412.02	412.99	196635.0
2021-05-14 08:30:00	SPY	ETF	412.99	413.2	412.02	413.0	475066.0
2021-05-14 09:00:00	SPY	ETF	413.009	413.21	412.73	413.21	291786.0
2021-05-14 09:30:00	SPY	ETF	413.2	414.92	413.18	414.92	7010547.0
2021-05-14 10:00:00	SPY	ETF	414.9	415.22	414.1699	414.44	6850480.0
2021-05-14 10:30:00	SPY	ETF	414.43	415.37	414.0714	415.28	4100382.0
2021-05-14 11:00:00	SPY	ETF	415.28	415.67	414.84	415.49	2827643.0
2021-05-14 11:30:00	SPY	ETF	415.49	415.75	415.27	415.39	2169379.0
2021-05-14 12:00:00	SPY	ETF	415.39	416.023	415.32	415.9	1861376.0
2021-05-14 12:30:00	SPY	ETF	415.9	416.27	415.78	416.24	1706561.0
2021-05-14 13:00:00	SPY	ETF	416.2389	416.44	416.07	416.375	1821299.0
2021-05-14 13:30:00	SPY	ETF	416.38	416.5206	416.16	416.43	1964982.0
2021-05-14 14:00:00	SPY	ETF	416.43	416.95	416.31	416.73	2723564.0
2021-05-14 14:30:00	SPY	ETF	416.73	417.49	416.73	417.2199	3316670.0
2021-05-14 15:00:00	SPY	ETF	417.215	417.34	416.71	417.03	3912215.0
2021-05-14 15:30:00	SPY	ETF	417.04	417.38	416.3	416.55	16174291.0
2021-05-14 16:00:00	SPY	ETF	416.55	417.29	415.9835	416.95	4351657.0
2021-05-14 16:30:00	SPY	ETF	416.95	417.15	416.93	417.02	250203.0
2021-05-14 17:00:00	SPY	ETF	416.99	417.12	416.58	417.07	94323.0
2021-05-14 17:30:00	SPY	ETF	417.07	417.08	416.76	416.96	40814.0
2021-05-14 18:00:00	SPY	ETF	416.96	417.13	416.93	417.13	9003.0
2021-05-14 18:30:00	SPY	ETF	417.15	417.22	417.08	417.14	26064.0
2021-05-14 19:00:00	SPY	ETF	417.13	417.19	417.11	417.19	4115.0
2021-05-14 19:30:00	SPY	ETF	417.23	417.45	417.15	417.44	32807.0
2021-05-14 04:00:00	QQQ	ETF	321.29	321.98	321.28	321.76	23538.0
2021-05-14 04:30:00	QQQ	ETF	321.87	322.34	321.84	322.2	34199.0
2021-05-14 05:00:00	QQQ	ETF	322.14	323.29	322.14	322.96	44543.0
2021-05-14 05:30:00	QQQ	ETF	323.06	323.17	322.7	322.75	38875.0
2021-05-14 06:00:00	QQQ	ETF	322.8	322.98	322.68	322.85	12876.0
2021-05-14 06:30:00	QQQ	ETF	322.85	322.85	322.49	322.49	50373.0
2021-05-14 07:00:00	QQQ	ETF	322.45	323.02	322.33	322.84	155900.0
2021-05-14 07:30:00	QQQ	ETF	322.81	323.0	322.55	322.66	125162.0
2021-05-14 08:00:00	QQQ	ETF	322.66	323.17	321.4	323.11	213188.0
2021-05-14 08:30:00	QQQ	ETF	323.09	323.13	321.92	322.81	308890.0
2021-05-14 09:00:00	QQQ	ETF	322.77	322.99	322.35	322.64	277756.0
2021-05-14 09:30:00	QQQ	ETF	322.63	323.495	322.08	323.48	5207706.0
2021-05-14 10:00:00	QQQ	ETF	323.47	324.48	322.641	324.01	3829918.0
2021-05-14 10:30:00	QQQ	ETF	324.01	324.95	323.94	324.93	2792394.0
2021-05-14 11:00:00	QQQ	ETF	324.95	325.28	324.51	325.05	2238768.0
2021-05-14 11:30:00	QQQ	ETF	325.06	325.4	324.94	325.0318	1889827.0
2021-05-14 12:00:00	QQQ	ETF	325.03	325.81	324.91	325.52	1546254.0
2021-05-14 12:30:00	QQQ	ETF	325.53	325.85	325.46	325.76	916803.0

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

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