PREVIEW / etf_30min / 2019-12-10

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-12-10.parquet
  size:    507 KB
  rows:    17,813

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-10 04:00:00	SPY	ETF	312.77	312.77	312.46	312.61	6086.0
2019-12-10 04:30:00	SPY	ETF	312.56	312.57	312.43	312.57	4018.0
2019-12-10 05:00:00	SPY	ETF	312.56	312.98	312.56	312.89	31619.0
2019-12-10 05:30:00	SPY	ETF	312.82	312.88	312.76	312.82	4555.0
2019-12-10 06:00:00	SPY	ETF	312.82	312.82	311.92	312.09	25591.0
2019-12-10 06:30:00	SPY	ETF	312.04	312.82	312.04	312.74	24421.0
2019-12-10 07:00:00	SPY	ETF	312.74	312.8	312.56	312.8	33803.0
2019-12-10 07:30:00	SPY	ETF	312.82	312.84	312.52	312.6	78005.0
2019-12-10 08:00:00	SPY	ETF	312.63	314.05	312.49	313.33	213283.0
2019-12-10 08:30:00	SPY	ETF	313.33	314.45	313.21	314.03	1529553.0
2019-12-10 09:00:00	SPY	ETF	314.04	314.1	313.79	313.8	532590.0
2019-12-10 09:30:00	SPY	ETF	313.82	313.86	312.81	313.5	7041463.0
2019-12-10 10:00:00	SPY	ETF	313.5	314.44	313.43	314.38	4219567.0
2019-12-10 10:30:00	SPY	ETF	314.39	314.42	313.98	314.31	2535192.0
2019-12-10 11:00:00	SPY	ETF	314.31	314.55	313.58	314.14	4046154.0
2019-12-10 11:30:00	SPY	ETF	314.14	314.25	313.905	313.995	1567268.0
2019-12-10 12:00:00	SPY	ETF	313.99	314.025	313.63	313.66	2143663.0
2019-12-10 12:30:00	SPY	ETF	313.67	314.0384	313.55	313.94	2551708.0
2019-12-10 13:00:00	SPY	ETF	313.94	314.14	313.92	313.985	983743.0
2019-12-10 13:30:00	SPY	ETF	313.99	313.9913	313.78	313.835	1704857.0
2019-12-10 14:00:00	SPY	ETF	313.84	314.17	313.81	313.94	1810282.0
2019-12-10 14:30:00	SPY	ETF	313.9301	314.06	313.78	313.91	2268376.0
2019-12-10 15:00:00	SPY	ETF	313.92	314.05	313.63	313.6499	2707740.0
2019-12-10 15:30:00	SPY	ETF	313.65	313.68	313.03	313.55	7183251.0
2019-12-10 16:00:00	SPY	ETF	313.54	313.86	313.5298	313.82	6806282.0
2019-12-10 16:30:00	SPY	ETF	313.82	313.95	313.53	313.94	286751.0
2019-12-10 17:00:00	SPY	ETF	313.95	313.95	313.92	313.92	19386.0
2019-12-10 17:30:00	SPY	ETF	313.93	313.99	313.84	313.85	66725.0
2019-12-10 18:00:00	SPY	ETF	313.81	314.01	313.7	313.84	364449.0
2019-12-10 18:30:00	SPY	ETF	313.76	313.77	313.6	313.6	41691.0
2019-12-10 19:00:00	SPY	ETF	313.67	313.72	313.65	313.72	2875.0
2019-12-10 19:30:00	SPY	ETF	313.65	313.65	313.3	313.49	86162.0
2019-12-10 04:00:00	QQQ	ETF	203.11	203.13	202.98	203.06	9241.0
2019-12-10 04:30:00	QQQ	ETF	203.05	203.19	202.98	203.09	17360.0
2019-12-10 05:00:00	QQQ	ETF	203.15	203.36	203.15	203.27	20977.0
2019-12-10 05:30:00	QQQ	ETF	203.19	203.26	203.12	203.16	3300.0
2019-12-10 06:00:00	QQQ	ETF	203.16	203.16	202.47	202.59	15414.0
2019-12-10 06:30:00	QQQ	ETF	202.58	203.1	202.56	203.04	25830.0
2019-12-10 07:00:00	QQQ	ETF	203.08	203.1	202.87	203.06	63459.0
2019-12-10 07:30:00	QQQ	ETF	203.11	203.12	202.87	202.94	47265.0
2019-12-10 08:00:00	QQQ	ETF	203.02	204.16	202.84	203.47	107258.0
2019-12-10 08:30:00	QQQ	ETF	203.51	204.52	203.41	204.26	756336.0
2019-12-10 09:00:00	QQQ	ETF	204.25	204.33	204.07	204.15	161153.0
2019-12-10 09:30:00	QQQ	ETF	204.17	204.2	203.44	204.02	2495982.0
2019-12-10 10:00:00	QQQ	ETF	204.02	204.7866	203.94	204.75	1255044.0
2019-12-10 10:30:00	QQQ	ETF	204.76	204.79	204.46	204.67	628400.0
2019-12-10 11:00:00	QQQ	ETF	204.68	204.88	204.09	204.54	1449252.0
2019-12-10 11:30:00	QQQ	ETF	204.53	204.59	204.3	204.4	554802.0
2019-12-10 12:00:00	QQQ	ETF	204.393	204.393	204.11	204.138	606660.0
2019-12-10 12:30:00	QQQ	ETF	204.13	204.38	204.11	204.34	505496.0

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

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