PREVIEW / etf_30min / 2021-06-08

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-06-08.parquet
  size:    596 KB
  rows:    23,013

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-06-08 04:00:00	SPY	ETF	422.07	422.15	421.95	422.09	14093.0
2021-06-08 04:30:00	SPY	ETF	422.05	422.41	422.05	422.41	62883.0
2021-06-08 05:00:00	SPY	ETF	422.35	422.79	422.28	422.79	32476.0
2021-06-08 05:30:00	SPY	ETF	422.71	422.74	422.59	422.66	2400.0
2021-06-08 06:00:00	SPY	ETF	422.59	422.59	421.0	421.3	42724.0
2021-06-08 06:30:00	SPY	ETF	421.29	422.53	421.05	422.5	266079.0
2021-06-08 07:00:00	SPY	ETF	422.5	422.87	422.37	422.69	45761.0
2021-06-08 07:30:00	SPY	ETF	422.74	423.03	422.67	423.03	64409.0
2021-06-08 08:00:00	SPY	ETF	422.66	423.38	421.4896	423.28	126135.0
2021-06-08 08:30:00	SPY	ETF	423.27	423.32	422.94	423.08	103041.0
2021-06-08 09:00:00	SPY	ETF	423.07	423.32	423.04	423.14	146366.0
2021-06-08 09:30:00	SPY	ETF	423.11	423.21	421.64	421.77	4918067.0
2021-06-08 10:00:00	SPY	ETF	421.75	422.26	421.54	421.88	2385586.0
2021-06-08 10:30:00	SPY	ETF	421.86	422.24	421.615	421.88	2634662.0
2021-06-08 11:00:00	SPY	ETF	421.89	422.22	420.32	420.94	4227744.0
2021-06-08 11:30:00	SPY	ETF	420.935	422.13	420.89	422.025	3541287.0
2021-06-08 12:00:00	SPY	ETF	422.02	422.485	421.92	422.455	1787386.0
2021-06-08 12:30:00	SPY	ETF	422.445	422.65	422.34	422.57	1390440.0
2021-06-08 13:00:00	SPY	ETF	422.57	422.63	422.23	422.235	1142743.0
2021-06-08 13:30:00	SPY	ETF	422.23	422.655	422.17	422.23	1181412.0
2021-06-08 14:00:00	SPY	ETF	422.24	422.595	422.14	422.585	1333770.0
2021-06-08 14:30:00	SPY	ETF	422.58	422.79	422.37	422.745	1235073.0
2021-06-08 15:00:00	SPY	ETF	422.75	422.94	422.565	422.71	1787010.0
2021-06-08 15:30:00	SPY	ETF	422.71	422.79	422.2425	422.27	6367135.0
2021-06-08 16:00:00	SPY	ETF	422.27	422.4	422.21	422.37	1803780.0
2021-06-08 16:30:00	SPY	ETF	422.34	422.34	422.05	422.25	211127.0
2021-06-08 17:00:00	SPY	ETF	422.25	422.25	422.2	422.2	2900.0
2021-06-08 17:30:00	SPY	ETF	422.21	422.28	422.21	422.23	6871.0
2021-06-08 18:00:00	SPY	ETF	422.28	422.37	421.97	422.36	45241.0
2021-06-08 18:30:00	SPY	ETF	422.37	422.4	422.28	422.4	10883.0
2021-06-08 19:00:00	SPY	ETF	422.4	422.4999	422.28	422.29	13944.0
2021-06-08 19:30:00	SPY	ETF	422.29	422.48	422.29	422.38	15015.0
2021-06-08 04:00:00	QQQ	ETF	336.84	336.84	336.44	336.61	10055.0
2021-06-08 04:30:00	QQQ	ETF	336.77	337.19	336.77	337.19	9900.0
2021-06-08 05:00:00	QQQ	ETF	337.17	337.6	337.16	337.6	8251.0
2021-06-08 05:30:00	QQQ	ETF	337.55	337.66	337.38	337.61	6237.0
2021-06-08 06:00:00	QQQ	ETF	337.59	337.6	336.16	336.45	57757.0
2021-06-08 06:30:00	QQQ	ETF	336.33	337.6	336.12	337.55	227752.0
2021-06-08 07:00:00	QQQ	ETF	337.48	338.0	337.4	337.78	83191.0
2021-06-08 07:30:00	QQQ	ETF	337.83	338.33	337.79	338.31	40103.0
2021-06-08 08:00:00	QQQ	ETF	337.3196	338.8	336.14	338.64	154359.0
2021-06-08 08:30:00	QQQ	ETF	338.66	338.77	338.22	338.38	183050.0
2021-06-08 09:00:00	QQQ	ETF	338.34	338.77	338.33	338.41	165021.0
2021-06-08 09:30:00	QQQ	ETF	338.38	339.29	337.22	337.41	3720065.0
2021-06-08 10:00:00	QQQ	ETF	337.41	337.79	337.01	337.14	1752102.0
2021-06-08 10:30:00	QQQ	ETF	337.1001	337.38	336.39	336.62	2036396.0
2021-06-08 11:00:00	QQQ	ETF	336.64	337.02	335.03	335.72	2398967.0
2021-06-08 11:30:00	QQQ	ETF	335.7	336.25	335.29	336.035	1568497.0
2021-06-08 12:00:00	QQQ	ETF	336.03	336.62	335.9	336.51	825660.0
2021-06-08 12:30:00	QQQ	ETF	336.495	337.05	336.475	337.0	847582.0

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

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