PREVIEW / etf_30min / 2020-05-11

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-05-11.parquet
  size:    554 KB
  rows:    20,575

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
2020-05-11 04:00:00	SPY	ETF	293.83	294.34	293.45	293.5	29781.0
2020-05-11 04:30:00	SPY	ETF	293.42	293.5	292.5	292.8	50007.0
2020-05-11 05:00:00	SPY	ETF	292.71	292.71	291.82	291.82	133106.0
2020-05-11 05:30:00	SPY	ETF	291.76	292.36	291.75	292.1	38010.0
2020-05-11 06:00:00	SPY	ETF	292.09	292.28	291.15	291.25	192015.0
2020-05-11 06:30:00	SPY	ETF	291.19	291.61	291.0	291.29	127594.0
2020-05-11 07:00:00	SPY	ETF	291.33	291.54	290.78	291.25	365583.0
2020-05-11 07:30:00	SPY	ETF	291.25	291.29	289.89	290.06	458830.0
2020-05-11 08:00:00	SPY	ETF	291.27	294.8	289.66	289.89	681598.0
2020-05-11 08:30:00	SPY	ETF	289.89	290.17	289.3399	289.78	507485.0
2020-05-11 09:00:00	SPY	ETF	289.77	290.43	289.74	290.32	474310.0
2020-05-11 09:30:00	SPY	ETF	290.34	291.21	289.88	290.45	8493271.0
2020-05-11 10:00:00	SPY	ETF	290.45	291.285	290.38	290.9	5790619.0
2020-05-11 10:30:00	SPY	ETF	290.89	291.41	290.55	290.88	4550690.0
2020-05-11 11:00:00	SPY	ETF	290.88	291.75	290.82	291.74	3705822.0
2020-05-11 11:30:00	SPY	ETF	291.75	292.0	291.7	291.9471	3233445.0
2020-05-11 12:00:00	SPY	ETF	291.93	292.77	291.71	292.73	3191764.0
2020-05-11 12:30:00	SPY	ETF	292.73	293.11	292.61	292.98	3534189.0
2020-05-11 13:00:00	SPY	ETF	292.98	293.81	292.77	293.68	3152293.0
2020-05-11 13:30:00	SPY	ETF	293.68	294.0	293.34	293.3599	3238410.0
2020-05-11 14:00:00	SPY	ETF	293.345	293.48	292.71	292.8759	4461334.0
2020-05-11 14:30:00	SPY	ETF	292.865	293.74	292.81	293.49	2911451.0
2020-05-11 15:00:00	SPY	ETF	293.5	294.0	293.2	293.4	4652018.0
2020-05-11 15:30:00	SPY	ETF	293.41	293.59	292.5	292.56	11437200.0
2020-05-11 16:00:00	SPY	ETF	292.58	293.0054	292.08	292.6	10330421.0
2020-05-11 16:30:00	SPY	ETF	292.63	292.66	292.15	292.19	2646041.0
2020-05-11 17:00:00	SPY	ETF	292.32	292.36	292.13	292.34	91888.0
2020-05-11 17:30:00	SPY	ETF	292.33	292.5	292.3	292.4	63608.0
2020-05-11 18:00:00	SPY	ETF	292.33	293.03	292.28	292.82	120597.0
2020-05-11 18:30:00	SPY	ETF	292.83	293.06	292.26	292.55	91063.0
2020-05-11 19:00:00	SPY	ETF	292.5	292.75	291.76	291.94	190596.0
2020-05-11 19:30:00	SPY	ETF	291.91	292.05	291.65	291.94	121572.0
2020-05-11 04:00:00	QQQ	ETF	225.9	226.01	225.44	225.5	29519.0
2020-05-11 04:30:00	QQQ	ETF	225.44	225.48	224.75	224.97	80318.0
2020-05-11 05:00:00	QQQ	ETF	224.88	224.88	224.44	224.5	25442.0
2020-05-11 05:30:00	QQQ	ETF	224.43	225.05	224.43	224.94	46568.0
2020-05-11 06:00:00	QQQ	ETF	224.9	225.01	224.12	224.12	45128.0
2020-05-11 06:30:00	QQQ	ETF	224.05	224.38	223.97	224.09	12526.0
2020-05-11 07:00:00	QQQ	ETF	224.28	224.47	223.97	224.24	68559.0
2020-05-11 07:30:00	QQQ	ETF	224.26	224.32	223.2	223.3	131020.0
2020-05-11 08:00:00	QQQ	ETF	224.11	226.53	222.86	222.9	237206.0
2020-05-11 08:30:00	QQQ	ETF	222.9	223.22	222.56	223.18	196212.0
2020-05-11 09:00:00	QQQ	ETF	223.18	223.53	223.15	223.5	174575.0
2020-05-11 09:30:00	QQQ	ETF	223.49	225.11	223.25	224.67	4798121.0
2020-05-11 10:00:00	QQQ	ETF	224.66	225.65	224.61	225.4135	2910137.0
2020-05-11 10:30:00	QQQ	ETF	225.41	225.85	224.88	225.24	2161661.0
2020-05-11 11:00:00	QQQ	ETF	225.26	226.04	225.13	226.0101	1514330.0
2020-05-11 11:30:00	QQQ	ETF	226.03	226.14	225.8205	226.131	1564235.0
2020-05-11 12:00:00	QQQ	ETF	226.12	226.46	225.845	226.43	2108007.0
2020-05-11 12:30:00	QQQ	ETF	226.4301	226.56	226.17	226.47	1629277.0

> showing 50 of 20,575 rows — these rows as CSV

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