PREVIEW / etf_30min / 2020-06-29

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-06-29.parquet
  size:    536 KB
  rows:    20,238

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-06-29 04:00:00	SPY	ETF	301.22	301.24	300.34	300.4	56082.0
2020-06-29 04:30:00	SPY	ETF	300.8	301.37	300.66	301.37	16265.0
2020-06-29 05:00:00	SPY	ETF	301.29	301.41	300.9	301.37	11816.0
2020-06-29 05:30:00	SPY	ETF	301.04	301.89	301.02	301.7	18049.0
2020-06-29 06:00:00	SPY	ETF	301.69	301.87	301.1	301.3	63560.0
2020-06-29 06:30:00	SPY	ETF	301.3	301.53	300.7	301.5	148748.0
2020-06-29 07:00:00	SPY	ETF	301.51	301.83	301.19	301.77	287261.0
2020-06-29 07:30:00	SPY	ETF	301.84	302.7	301.5	302.44	355353.0
2020-06-29 08:00:00	SPY	ETF	302.5	302.65	300.01	301.98	468748.0
2020-06-29 08:30:00	SPY	ETF	301.9	302.05	301.14	301.46	755551.0
2020-06-29 09:00:00	SPY	ETF	301.5	301.63	301.12	301.4	282244.0
2020-06-29 09:30:00	SPY	ETF	301.41	301.7299	298.93	300.59	11109674.0
2020-06-29 10:00:00	SPY	ETF	300.575	302.38	300.57	301.95	6582425.0
2020-06-29 10:30:00	SPY	ETF	301.97	303.43	301.92	302.58	5959531.0
2020-06-29 11:00:00	SPY	ETF	302.59	303.33	301.49	303.21	7041684.0
2020-06-29 11:30:00	SPY	ETF	303.2	303.38	302.5716	302.69	3583365.0
2020-06-29 12:00:00	SPY	ETF	302.69	303.67	302.69	303.54	2766420.0
2020-06-29 12:30:00	SPY	ETF	303.55	303.81	303.27	303.35	2908594.0
2020-06-29 13:00:00	SPY	ETF	303.35	303.62	303.21	303.575	1878900.0
2020-06-29 13:30:00	SPY	ETF	303.57	304.02	303.38	303.63	2658230.0
2020-06-29 14:00:00	SPY	ETF	303.635	303.83	303.04	303.12	2464708.0
2020-06-29 14:30:00	SPY	ETF	303.12	303.51	302.7	302.93	3798612.0
2020-06-29 15:00:00	SPY	ETF	302.94	303.099	302.22	302.82	4350330.0
2020-06-29 15:30:00	SPY	ETF	302.825	304.45	302.44	304.43	12544238.0
2020-06-29 16:00:00	SPY	ETF	304.42	305.0	304.3256	304.7	6676438.0
2020-06-29 16:30:00	SPY	ETF	304.72	305.17	304.46	304.7	627537.0
2020-06-29 17:00:00	SPY	ETF	304.87	304.87	304.5	304.71	161341.0
2020-06-29 17:30:00	SPY	ETF	304.73	304.85	304.46	304.7	95701.0
2020-06-29 18:00:00	SPY	ETF	304.65	305.51	304.53	305.41	142326.0
2020-06-29 18:30:00	SPY	ETF	305.41	305.98	305.4	305.66	86831.0
2020-06-29 19:00:00	SPY	ETF	305.67	305.74	305.51	305.6	42465.0
2020-06-29 19:30:00	SPY	ETF	305.67	305.99	305.35	305.47	89565.0
2020-06-29 04:00:00	QQQ	ETF	240.48	240.48	239.76	239.88	51563.0
2020-06-29 04:30:00	QQQ	ETF	240.13	240.5	240.1	240.43	25706.0
2020-06-29 05:00:00	QQQ	ETF	240.42	240.44	240.05	240.4	20480.0
2020-06-29 05:30:00	QQQ	ETF	240.06	240.6	240.06	240.5	129900.0
2020-06-29 06:00:00	QQQ	ETF	240.5	240.6	239.92	240.1	27399.0
2020-06-29 06:30:00	QQQ	ETF	240.17	240.33	239.75	240.28	23067.0
2020-06-29 07:00:00	QQQ	ETF	240.33	240.35	239.9	240.28	47482.0
2020-06-29 07:30:00	QQQ	ETF	240.28	241.18	240.11	241.01	87672.0
2020-06-29 08:00:00	QQQ	ETF	240.2699	241.08	239.38	240.39	145076.0
2020-06-29 08:30:00	QQQ	ETF	240.36	240.53	239.97	240.22	123933.0
2020-06-29 09:00:00	QQQ	ETF	240.23	240.33	239.9	239.96	113851.0
2020-06-29 09:30:00	QQQ	ETF	239.98	240.2995	237.35	238.89	6037867.0
2020-06-29 10:00:00	QQQ	ETF	238.92	240.45	238.63	240.09	3645567.0
2020-06-29 10:30:00	QQQ	ETF	240.1	241.22	239.97	240.51	2858472.0
2020-06-29 11:00:00	QQQ	ETF	240.52	241.37	239.8	241.27	2136987.0
2020-06-29 11:30:00	QQQ	ETF	241.26	241.5614	241.03	241.3414	1626253.0
2020-06-29 12:00:00	QQQ	ETF	241.33	242.05	241.33	241.94	1359809.0
2020-06-29 12:30:00	QQQ	ETF	241.9576	242.1801	241.8415	241.97	822874.0

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

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