PREVIEW / etf_1hour / 2020-04-17

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-04-17.parquet
  size:    383 KB
  rows:    12,987

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-04-17 04:00:00	SPY	ETF	286.15	287.54	285.95	285.98	222857.0
2020-04-17 05:00:00	SPY	ETF	285.97	287.41	285.56	286.81	181286.0
2020-04-17 06:00:00	SPY	ETF	286.98	287.87	286.68	287.65	424198.0
2020-04-17 07:00:00	SPY	ETF	287.56	288.13	286.64	287.13	972280.0
2020-04-17 08:00:00	SPY	ETF	288.0399	288.5	285.8	286.3	1653103.0
2020-04-17 09:00:00	SPY	ETF	286.29	286.45	284.06	285.46	18664485.0
2020-04-17 10:00:00	SPY	ETF	285.47	285.67	282.55	283.38	28078124.0
2020-04-17 11:00:00	SPY	ETF	283.385	284.0	282.4	283.51	16044851.0
2020-04-17 12:00:00	SPY	ETF	283.53	284.65	282.92	284.34	13085969.0
2020-04-17 13:00:00	SPY	ETF	284.33	284.77	283.77	284.0801	10960330.0
2020-04-17 14:00:00	SPY	ETF	284.08	284.08	282.65	283.62	9660751.0
2020-04-17 15:00:00	SPY	ETF	283.62	287.3	283.5	286.73	33047580.0
2020-04-17 16:00:00	SPY	ETF	286.72	288.0	284.2049	287.15	10407959.0
2020-04-17 17:00:00	SPY	ETF	287.24	287.29	286.64	286.65	1632901.0
2020-04-17 18:00:00	SPY	ETF	286.64	286.69	286.31	286.44	126036.0
2020-04-17 19:00:00	SPY	ETF	286.44	286.7	286.4	286.66	82968.0
2020-04-17 04:00:00	QQQ	ETF	216.98	217.8	216.71	216.98	74901.0
2020-04-17 05:00:00	QQQ	ETF	216.98	217.88	216.8	217.62	52824.0
2020-04-17 06:00:00	QQQ	ETF	217.73	218.24	217.54	218.02	172970.0
2020-04-17 07:00:00	QQQ	ETF	218.06	218.38	217.15	217.3	427031.0
2020-04-17 08:00:00	QQQ	ETF	218.2601	218.48	216.62	216.81	553369.0
2020-04-17 09:00:00	QQQ	ETF	216.7401	216.95	213.89	215.35	9955668.0
2020-04-17 10:00:00	QQQ	ETF	215.31	215.89	213.325	213.95	8580581.0
2020-04-17 11:00:00	QQQ	ETF	213.95	214.42	212.71	213.45	5887682.0
2020-04-17 12:00:00	QQQ	ETF	213.45	213.9694	212.77	213.705	3831652.0
2020-04-17 13:00:00	QQQ	ETF	213.69	213.8599	213.11	213.245	3435449.0
2020-04-17 14:00:00	QQQ	ETF	213.23	213.25	212.0801	212.95	4638505.0
2020-04-17 15:00:00	QQQ	ETF	212.95	215.5	212.86	215.19	9966903.0
2020-04-17 16:00:00	QQQ	ETF	215.18	215.29	214.74	215.01	1339562.0
2020-04-17 17:00:00	QQQ	ETF	214.91	215.29	214.66	214.89	234053.0
2020-04-17 18:00:00	QQQ	ETF	215.29	215.29	214.55	214.65	113921.0
2020-04-17 19:00:00	QQQ	ETF	214.63	214.84	214.56	214.83	24154.0
2020-04-17 04:00:00	IWM	ETF	123.1	123.1	122.5	122.5	15090.0
2020-04-17 05:00:00	IWM	ETF	122.3	123.15	122.24	122.85	45148.0
2020-04-17 06:00:00	IWM	ETF	122.9	123.15	122.9	123.1	34042.0
2020-04-17 07:00:00	IWM	ETF	123.15	123.2	122.5	122.61	180660.0
2020-04-17 08:00:00	IWM	ETF	122.68	123.98	122.12	122.25	326352.0
2020-04-17 09:00:00	IWM	ETF	122.23	122.55	120.76	122.49	5969703.0
2020-04-17 10:00:00	IWM	ETF	122.5	122.52	120.06	120.58	7862481.0
2020-04-17 11:00:00	IWM	ETF	120.57	121.53	120.4301	121.29	3177168.0
2020-04-17 12:00:00	IWM	ETF	121.2911	122.145	121.105	121.8965	3097045.0
2020-04-17 13:00:00	IWM	ETF	121.885	122.02	121.1	121.34	2657264.0
2020-04-17 14:00:00	IWM	ETF	121.33	121.4	120.87	121.36	2672621.0
2020-04-17 15:00:00	IWM	ETF	121.36	122.72	121.24	122.11	7410070.0
2020-04-17 16:00:00	IWM	ETF	122.11	122.25	121.85	121.94	2740274.0
2020-04-17 17:00:00	IWM	ETF	121.92	122.06	121.89	121.99	937682.0
2020-04-17 18:00:00	IWM	ETF	121.88	122.06	121.69	121.82	12765.0
2020-04-17 19:00:00	IWM	ETF	121.82	121.84	121.68	121.81	7132.0
2020-04-17 04:00:00	DIA	ETF	243.44	243.44	241.75	241.75	5650.0
2020-04-17 05:00:00	DIA	ETF	241.86	242.6	241.6	242.25	2105.0

> showing 50 of 12,987 rows — these rows as CSV

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