PREVIEW / etf_30min / 2019-12-11

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-12-11.parquet
  size:    513 KB
  rows:    17,846

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
2019-12-11 04:00:00	SPY	ETF	313.5	313.77	313.5	313.7	3391.0
2019-12-11 04:30:00	SPY	ETF	313.69	313.72	313.69	313.7	990.0
2019-12-11 05:00:00	SPY	ETF	313.8	313.85	313.78	313.78	4001.0
2019-12-11 05:30:00	SPY	ETF	313.75	313.75	313.52	313.7	7287.0
2019-12-11 06:00:00	SPY	ETF	313.76	313.81	313.6	313.6	3828.0
2019-12-11 06:30:00	SPY	ETF	313.7	313.95	313.7	313.95	7052.0
2019-12-11 07:00:00	SPY	ETF	313.99	314.1	313.87	313.88	151035.0
2019-12-11 07:30:00	SPY	ETF	313.91	314.16	313.89	314.13	21935.0
2019-12-11 08:00:00	SPY	ETF	314.11	314.5	313.64	314.19	83840.0
2019-12-11 08:30:00	SPY	ETF	314.2	314.38	314.03	314.27	92821.0
2019-12-11 09:00:00	SPY	ETF	314.25	314.32	314.05	314.06	161627.0
2019-12-11 09:30:00	SPY	ETF	314.03	314.44	313.7	314.44	3270330.0
2019-12-11 10:00:00	SPY	ETF	314.43	314.55	314.18	314.25	2696005.0
2019-12-11 10:30:00	SPY	ETF	314.24	314.245	313.83	313.8681	3084778.0
2019-12-11 11:00:00	SPY	ETF	313.85	314.01	313.62	313.93	2044679.0
2019-12-11 11:30:00	SPY	ETF	313.94	314.08	313.67	313.75	2239830.0
2019-12-11 12:00:00	SPY	ETF	313.74	313.85	313.63	313.725	2298576.0
2019-12-11 12:30:00	SPY	ETF	313.72	313.84	313.61	313.8	1199183.0
2019-12-11 13:00:00	SPY	ETF	313.79	313.86	313.69	313.82	1336960.0
2019-12-11 13:30:00	SPY	ETF	313.82	313.91	313.595	313.88	2151586.0
2019-12-11 14:00:00	SPY	ETF	313.87	314.435	313.7	314.26	4439300.0
2019-12-11 14:30:00	SPY	ETF	314.255	314.66	314.11	314.63	4549420.0
2019-12-11 15:00:00	SPY	ETF	314.64	314.7	314.18	314.415	3138497.0
2019-12-11 15:30:00	SPY	ETF	314.415	314.63	314.09	314.41	8658269.0
2019-12-11 16:00:00	SPY	ETF	314.4	314.59	314.31	314.5	6149623.0
2019-12-11 16:30:00	SPY	ETF	314.5	314.65	313.5312	314.63	419178.0
2019-12-11 17:00:00	SPY	ETF	314.63	314.63	314.5	314.55	128918.0
2019-12-11 17:30:00	SPY	ETF	314.52	314.68	314.52	314.66	190977.0
2019-12-11 18:00:00	SPY	ETF	314.64	314.72	314.6	314.7	49262.0
2019-12-11 18:30:00	SPY	ETF	314.72	314.85	314.71	314.84	14454.0
2019-12-11 19:00:00	SPY	ETF	314.8	314.8	314.6	314.6	27926.0
2019-12-11 19:30:00	SPY	ETF	314.62	314.65	314.57	314.65	30402.0
2019-12-11 04:00:00	QQQ	ETF	204.03	204.12	204.02	204.1	2237.0
2019-12-11 04:30:00	QQQ	ETF	203.91	204.02	203.91	204.02	300.0
2019-12-11 05:00:00	QQQ	ETF	204.11	204.17	204.11	204.12	700.0
2019-12-11 05:30:00	QQQ	ETF	203.94	203.99	203.91	203.95	1900.0
2019-12-11 06:00:00	QQQ	ETF	204.09	204.15	204.0	204.0	3865.0
2019-12-11 06:30:00	QQQ	ETF	204.05	204.28	204.05	204.28	13466.0
2019-12-11 07:00:00	QQQ	ETF	204.29	204.34	204.2	204.2	13096.0
2019-12-11 07:30:00	QQQ	ETF	204.21	204.46	204.21	204.42	24489.0
2019-12-11 08:00:00	QQQ	ETF	204.33	204.51	203.94	204.41	291794.0
2019-12-11 08:30:00	QQQ	ETF	204.4	204.6	204.38	204.54	38600.0
2019-12-11 09:00:00	QQQ	ETF	204.54	204.58	204.31	204.37	74130.0
2019-12-11 09:30:00	QQQ	ETF	204.37	204.67	204.04	204.67	1103336.0
2019-12-11 10:00:00	QQQ	ETF	204.67	204.84	204.555	204.605	621211.0
2019-12-11 10:30:00	QQQ	ETF	204.615	204.69	204.39	204.42	537921.0
2019-12-11 11:00:00	QQQ	ETF	204.41	204.58	204.21	204.535	668657.0
2019-12-11 11:30:00	QQQ	ETF	204.53	204.62	204.32	204.38	513528.0
2019-12-11 12:00:00	QQQ	ETF	204.37	204.45	204.32	204.355	355821.0
2019-12-11 12:30:00	QQQ	ETF	204.36	204.41	204.225	204.38	354278.0

> showing 50 of 17,846 rows — these rows as CSV

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