PREVIEW / etf_30min / 2021-04-15

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-04-15.parquet
  size:    627 KB
  rows:    23,520

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-04-15 04:00:00	SPY	ETF	413.19	413.32	413.16	413.27	9065.0
2021-04-15 04:30:00	SPY	ETF	413.12	413.34	413.11	413.31	9189.0
2021-04-15 05:00:00	SPY	ETF	413.31	413.4	413.21	413.32	13997.0
2021-04-15 05:30:00	SPY	ETF	413.31	413.31	413.13	413.14	4683.0
2021-04-15 06:00:00	SPY	ETF	413.09	413.28	413.05	413.27	4000.0
2021-04-15 06:30:00	SPY	ETF	413.19	413.5	413.19	413.5	8149.0
2021-04-15 07:00:00	SPY	ETF	413.44	413.46	413.12	413.19	49969.0
2021-04-15 07:30:00	SPY	ETF	413.19	413.67	413.08	413.67	165140.0
2021-04-15 08:00:00	SPY	ETF	413.4001	413.96	412.24	413.73	176546.0
2021-04-15 08:30:00	SPY	ETF	413.88	414.12	413.66	413.79	233141.0
2021-04-15 09:00:00	SPY	ETF	413.8	413.83	413.47	413.77	183942.0
2021-04-15 09:30:00	SPY	ETF	413.74	414.37	413.69	413.95	5671794.0
2021-04-15 10:00:00	SPY	ETF	413.97	414.56	413.75	414.56	3631274.0
2021-04-15 10:30:00	SPY	ETF	414.56	415.16	414.555	414.91	3864423.0
2021-04-15 11:00:00	SPY	ETF	414.92	415.46	414.585	414.6457	3339759.0
2021-04-15 11:30:00	SPY	ETF	414.649	414.865	414.52	414.82	2480716.0
2021-04-15 12:00:00	SPY	ETF	414.8159	415.23	414.7	415.17	1891370.0
2021-04-15 12:30:00	SPY	ETF	415.18	415.68	415.18	415.6299	1934945.0
2021-04-15 13:00:00	SPY	ETF	415.63	415.7	415.09	415.299	2823573.0
2021-04-15 13:30:00	SPY	ETF	415.3	415.61	415.27	415.4091	1679517.0
2021-04-15 14:00:00	SPY	ETF	415.405	415.6701	415.24	415.61	2914777.0
2021-04-15 14:30:00	SPY	ETF	415.61	415.79	415.18	415.36	1991288.0
2021-04-15 15:00:00	SPY	ETF	415.35	415.53	414.89	414.97	3700750.0
2021-04-15 15:30:00	SPY	ETF	414.965	416.16	414.95	415.83	10059619.0
2021-04-15 16:00:00	SPY	ETF	415.83	415.93	415.63	415.71	1928176.0
2021-04-15 16:30:00	SPY	ETF	415.71	415.91	415.62	415.79	115098.0
2021-04-15 17:00:00	SPY	ETF	415.83	415.95	415.77	415.86	62186.0
2021-04-15 17:30:00	SPY	ETF	415.86	415.93	415.85	415.87	10343.0
2021-04-15 18:00:00	SPY	ETF	415.83	415.88	415.62	415.8	63231.0
2021-04-15 18:30:00	SPY	ETF	415.81	415.85	415.7	415.83	48094.0
2021-04-15 19:00:00	SPY	ETF	415.8	415.87	415.79	415.85	5495.0
2021-04-15 19:30:00	SPY	ETF	415.86	415.93	415.81	415.82	36672.0
2021-04-15 04:00:00	QQQ	ETF	338.22	338.37	337.52	338.11	17339.0
2021-04-15 04:30:00	QQQ	ETF	338.14	338.37	338.13	338.36	21229.0
2021-04-15 05:00:00	QQQ	ETF	338.41	338.51	338.17	338.23	19002.0
2021-04-15 05:30:00	QQQ	ETF	338.15	338.39	338.15	338.23	10140.0
2021-04-15 06:00:00	QQQ	ETF	338.06	338.36	337.95	338.27	41629.0
2021-04-15 06:30:00	QQQ	ETF	338.25	338.76	338.16	338.7	30372.0
2021-04-15 07:00:00	QQQ	ETF	338.71	338.81	338.28	338.54	67180.0
2021-04-15 07:30:00	QQQ	ETF	338.54	339.12	338.45	339.12	108811.0
2021-04-15 08:00:00	QQQ	ETF	338.79	339.5	336.51	339.37	140383.0
2021-04-15 08:30:00	QQQ	ETF	339.25	339.85	339.16	339.63	179940.0
2021-04-15 09:00:00	QQQ	ETF	339.65	339.69	339.29	339.49	142221.0
2021-04-15 09:30:00	QQQ	ETF	339.49	340.66	339.33	340.11	3964448.0
2021-04-15 10:00:00	QQQ	ETF	340.13	340.93	339.55	340.93	2877331.0
2021-04-15 10:30:00	QQQ	ETF	340.92	341.25	340.575	340.7599	2003307.0
2021-04-15 11:00:00	QQQ	ETF	340.82	341.4999	340.4	340.475	2017659.0
2021-04-15 11:30:00	QQQ	ETF	340.48	340.68	340.02	340.24	1547612.0
2021-04-15 12:00:00	QQQ	ETF	340.25	340.75	339.811	340.66	1092884.0
2021-04-15 12:30:00	QQQ	ETF	340.69	341.435	340.675	341.39	1115037.0

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

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