PREVIEW / etf_30min / 2021-05-18

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-05-18.parquet
  size:    607 KB
  rows:    23,420

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-18 04:00:00	SPY	ETF	417.07	417.08	416.87	416.94	17076.0
2021-05-18 04:30:00	SPY	ETF	417.05	417.05	416.77	416.77	2826.0
2021-05-18 05:00:00	SPY	ETF	416.75	417.01	416.73	416.73	5650.0
2021-05-18 05:30:00	SPY	ETF	416.8	416.8	416.67	416.74	8272.0
2021-05-18 06:00:00	SPY	ETF	416.67	417.05	416.65	416.67	5998.0
2021-05-18 06:30:00	SPY	ETF	416.73	416.83	416.55	416.66	9227.0
2021-05-18 07:00:00	SPY	ETF	416.68	416.78	415.98	416.2	105844.0
2021-05-18 07:30:00	SPY	ETF	416.23	416.47	416.15	416.16	167071.0
2021-05-18 08:00:00	SPY	ETF	416.15	417.55	416.01	416.28	87806.0
2021-05-18 08:30:00	SPY	ETF	416.33	416.36	415.7	415.88	126063.0
2021-05-18 09:00:00	SPY	ETF	415.87	415.89	415.46	415.78	197213.0
2021-05-18 09:30:00	SPY	ETF	415.8	416.06	414.82	415.11	5801054.0
2021-05-18 10:00:00	SPY	ETF	415.1	415.77	414.46	415.77	4071030.0
2021-05-18 10:30:00	SPY	ETF	415.77	415.98	415.27	415.71	3225882.0
2021-05-18 11:00:00	SPY	ETF	415.7	415.8199	415.47	415.52	1704429.0
2021-05-18 11:30:00	SPY	ETF	415.52	415.58	414.86	414.89	2460641.0
2021-05-18 12:00:00	SPY	ETF	414.89	415.46	414.75	415.4119	1905352.0
2021-05-18 12:30:00	SPY	ETF	415.41	415.52	415.14	415.27	1162175.0
2021-05-18 13:00:00	SPY	ETF	415.27	415.57	414.96	415.525	1644954.0
2021-05-18 13:30:00	SPY	ETF	415.54	415.59	414.96	414.99	1525300.0
2021-05-18 14:00:00	SPY	ETF	414.97	415.1	414.33	414.41	2382670.0
2021-05-18 14:30:00	SPY	ETF	414.4	414.5	413.1	413.99	4453237.0
2021-05-18 15:00:00	SPY	ETF	413.99	414.4	413.77	414.27	2805625.0
2021-05-18 15:30:00	SPY	ETF	414.28	414.59	411.77	411.98	11625297.0
2021-05-18 16:00:00	SPY	ETF	411.99	412.32	411.79	411.86	3446440.0
2021-05-18 16:30:00	SPY	ETF	411.9	411.96	410.96	411.17	516055.0
2021-05-18 17:00:00	SPY	ETF	411.17	411.29	411.05	411.2	52321.0
2021-05-18 17:30:00	SPY	ETF	411.11	411.23	411.03	411.12	25610.0
2021-05-18 18:00:00	SPY	ETF	411.12	411.61	411.09	411.41	125626.0
2021-05-18 18:30:00	SPY	ETF	411.94	411.94	411.45	411.5	100578.0
2021-05-18 19:00:00	SPY	ETF	411.48	411.91	411.48	411.81	195234.0
2021-05-18 19:30:00	SPY	ETF	411.77	411.78	410.6	410.6	208749.0
2021-05-18 04:00:00	QQQ	ETF	326.51	327.0	326.51	326.81	32770.0
2021-05-18 04:30:00	QQQ	ETF	326.76	326.99	326.69	326.77	10909.0
2021-05-18 05:00:00	QQQ	ETF	326.6	327.05	326.6	326.79	13361.0
2021-05-18 05:30:00	QQQ	ETF	326.85	326.99	326.75	326.9	20761.0
2021-05-18 06:00:00	QQQ	ETF	327.05	327.07	326.5	326.56	20404.0
2021-05-18 06:30:00	QQQ	ETF	326.71	326.71	326.46	326.6	12501.0
2021-05-18 07:00:00	QQQ	ETF	326.68	326.68	325.91	326.17	82659.0
2021-05-18 07:30:00	QQQ	ETF	326.16	326.27	326.06	326.1	53832.0
2021-05-18 08:00:00	QQQ	ETF	326.73	327.36	325.65	326.19	72265.0
2021-05-18 08:30:00	QQQ	ETF	326.18	326.371	325.63	325.92	122498.0
2021-05-18 09:00:00	QQQ	ETF	325.88	325.88	325.23	325.41	171968.0
2021-05-18 09:30:00	QQQ	ETF	325.41	325.81	324.3	324.97	4355329.0
2021-05-18 10:00:00	QQQ	ETF	324.97	326.31	324.55	326.31	2891752.0
2021-05-18 10:30:00	QQQ	ETF	326.32	326.65	325.9101	326.34	2374527.0
2021-05-18 11:00:00	QQQ	ETF	326.33	326.54	326.03	326.07	984379.0
2021-05-18 11:30:00	QQQ	ETF	326.07	326.14	324.9894	325.02	1597410.0
2021-05-18 12:00:00	QQQ	ETF	325.03	325.96	324.95	325.93	1149144.0
2021-05-18 12:30:00	QQQ	ETF	325.93	326.14	325.56	325.71	788349.0

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

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