PREVIEW / etf_30min / 2021-06-15

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-06-15.parquet
  size:    594 KB
  rows:    22,729

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-15 04:00:00	SPY	ETF	425.97	425.99	425.66	425.74	10172.0
2021-06-15 04:30:00	SPY	ETF	425.74	425.93	425.74	425.9	5149.0
2021-06-15 05:00:00	SPY	ETF	425.83	425.86	425.68	425.69	1760.0
2021-06-15 05:30:00	SPY	ETF	425.6	425.75	425.48	425.48	16004.0
2021-06-15 06:00:00	SPY	ETF	425.43	425.43	425.27	425.42	64728.0
2021-06-15 06:30:00	SPY	ETF	425.45	425.59	425.35	425.58	3978.0
2021-06-15 07:00:00	SPY	ETF	425.68	425.69	425.56	425.62	20193.0
2021-06-15 07:30:00	SPY	ETF	425.62	425.84	425.56	425.72	32454.0
2021-06-15 08:00:00	SPY	ETF	425.68	425.84	425.2117	425.55	64214.0
2021-06-15 08:30:00	SPY	ETF	425.56	425.61	425.28	425.36	83239.0
2021-06-15 09:00:00	SPY	ETF	425.36	425.5899	425.3	425.44	175696.0
2021-06-15 09:30:00	SPY	ETF	425.43	425.46	424.56	424.695	3301385.0
2021-06-15 10:00:00	SPY	ETF	424.7	424.79	424.25	424.37	2289672.0
2021-06-15 10:30:00	SPY	ETF	424.37	424.48	424.01	424.0501	2230338.0
2021-06-15 11:00:00	SPY	ETF	424.04	424.35	423.9	424.13	1969809.0
2021-06-15 11:30:00	SPY	ETF	424.135	424.135	423.54	423.93	1727667.0
2021-06-15 12:00:00	SPY	ETF	423.93	424.45	423.92	424.4117	1179630.0
2021-06-15 12:30:00	SPY	ETF	424.41	424.49	424.03	424.22	1532953.0
2021-06-15 13:00:00	SPY	ETF	424.23	424.36	423.9301	424.11	1193356.0
2021-06-15 13:30:00	SPY	ETF	424.1081	424.74	424.06	424.65	1506692.0
2021-06-15 14:00:00	SPY	ETF	424.645	425.01	424.42	424.615	2090562.0
2021-06-15 14:30:00	SPY	ETF	424.615	424.9999	424.45	424.76	1670762.0
2021-06-15 15:00:00	SPY	ETF	424.76	424.79	424.275	424.435	2442209.0
2021-06-15 15:30:00	SPY	ETF	424.435	424.98	424.03	424.5	9353554.0
2021-06-15 16:00:00	SPY	ETF	424.5	424.8476	424.35	424.38	3819658.0
2021-06-15 16:30:00	SPY	ETF	424.39	424.61	424.36	424.51	120464.0
2021-06-15 17:00:00	SPY	ETF	424.42	424.57	424.42	424.5	21441.0
2021-06-15 17:30:00	SPY	ETF	424.46	424.54	424.38	424.48	10355.0
2021-06-15 18:00:00	SPY	ETF	424.53	424.71	424.53	424.64	23263.0
2021-06-15 18:30:00	SPY	ETF	424.48	424.61	424.45	424.46	9599.0
2021-06-15 19:00:00	SPY	ETF	424.41	424.49	424.34	424.34	5444.0
2021-06-15 19:30:00	SPY	ETF	424.33	424.55	424.28	424.44	28028.0
2021-06-15 04:00:00	QQQ	ETF	344.9	345.01	344.76	344.86	27007.0
2021-06-15 04:30:00	QQQ	ETF	344.87	344.93	344.79	344.9	11742.0
2021-06-15 05:00:00	QQQ	ETF	344.85	344.89	344.76	344.85	11873.0
2021-06-15 05:30:00	QQQ	ETF	344.65	344.8	344.61	344.65	11675.0
2021-06-15 06:00:00	QQQ	ETF	344.53	344.66	344.45	344.66	4984.0
2021-06-15 06:30:00	QQQ	ETF	344.63	344.9	344.55	344.9	8075.0
2021-06-15 07:00:00	QQQ	ETF	344.9	344.92	344.731	344.74	118720.0
2021-06-15 07:30:00	QQQ	ETF	344.74	345.0	344.7	344.88	68178.0
2021-06-15 08:00:00	QQQ	ETF	344.85	345.04	344.45	344.91	99897.0
2021-06-15 08:30:00	QQQ	ETF	344.95	345.03	344.17	344.2699	194421.0
2021-06-15 09:00:00	QQQ	ETF	344.239	344.25	343.88	344.18	220915.0
2021-06-15 09:30:00	QQQ	ETF	344.15	344.47	343.03	343.88	4192860.0
2021-06-15 10:00:00	QQQ	ETF	343.89	344.03	342.89	342.98	2651839.0
2021-06-15 10:30:00	QQQ	ETF	342.98	343.33	342.73	342.95	1982354.0
2021-06-15 11:00:00	QQQ	ETF	342.94	343.35	342.6	342.73	1245668.0
2021-06-15 11:30:00	QQQ	ETF	342.74	342.9	342.19	342.87	1531758.0
2021-06-15 12:00:00	QQQ	ETF	342.88	343.09	342.81	343.03	977179.0
2021-06-15 12:30:00	QQQ	ETF	343.02	343.075	342.27	342.435	1214700.0

> showing 50 of 22,729 rows — these rows as CSV

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