PREVIEW / etf_1hour / 2020-05-06

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-05-06.parquet
  size:    360 KB
  rows:    12,304

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-06 04:00:00	SPY	ETF	287.76	288.3	287.48	287.94	26112.0
2020-05-06 05:00:00	SPY	ETF	288.03	288.71	287.87	288.71	91841.0
2020-05-06 06:00:00	SPY	ETF	288.75	288.96	288.5	288.65	81677.0
2020-05-06 07:00:00	SPY	ETF	288.66	288.75	287.78	287.78	256119.0
2020-05-06 08:00:00	SPY	ETF	288.35	288.7204	286.06	287.54	897439.0
2020-05-06 09:00:00	SPY	ETF	287.52	288.46	285.83	286.355	7909871.0
2020-05-06 10:00:00	SPY	ETF	286.33	287.86	285.06	287.17	12244819.0
2020-05-06 11:00:00	SPY	ETF	287.165	287.58	285.53	286.12	8650498.0
2020-05-06 12:00:00	SPY	ETF	286.1	287.05	285.85	286.64	6103437.0
2020-05-06 13:00:00	SPY	ETF	286.64	287.42	285.97	287.01	5605416.0
2020-05-06 14:00:00	SPY	ETF	287.0	287.01	285.74	286.256	7441901.0
2020-05-06 15:00:00	SPY	ETF	286.2501	286.58	283.78	284.29	17963137.0
2020-05-06 16:00:00	SPY	ETF	284.31	284.46	283.4	283.82	4721735.0
2020-05-06 17:00:00	SPY	ETF	283.87	284.25	283.73	283.73	435991.0
2020-05-06 18:00:00	SPY	ETF	283.73	284.17	282.7	283.02	471979.0
2020-05-06 19:00:00	SPY	ETF	283.03	283.7	282.9	283.68	179781.0
2020-05-06 04:00:00	QQQ	ETF	219.06	219.47	219.0	219.0	25087.0
2020-05-06 05:00:00	QQQ	ETF	219.29	219.75	219.29	219.75	46061.0
2020-05-06 06:00:00	QQQ	ETF	219.75	219.85	219.5	219.5	23440.0
2020-05-06 07:00:00	QQQ	ETF	219.54	219.65	219.24	219.27	88911.0
2020-05-06 08:00:00	QQQ	ETF	219.4201	219.71	217.71	219.08	298472.0
2020-05-06 09:00:00	QQQ	ETF	219.14	220.35	218.92	219.37	4628907.0
2020-05-06 10:00:00	QQQ	ETF	219.36	220.78	218.11	220.345	6484432.0
2020-05-06 11:00:00	QQQ	ETF	220.34	220.7	219.44	219.9399	4617458.0
2020-05-06 12:00:00	QQQ	ETF	219.94	220.695	219.72	220.3585	2473072.0
2020-05-06 13:00:00	QQQ	ETF	220.36	221.04	219.97	220.69	3047871.0
2020-05-06 14:00:00	QQQ	ETF	220.68	220.7	219.88	220.0915	3229291.0
2020-05-06 15:00:00	QQQ	ETF	220.1	220.49	218.41	218.97	5573609.0
2020-05-06 16:00:00	QQQ	ETF	218.98	219.9103	218.26	218.47	887372.0
2020-05-06 17:00:00	QQQ	ETF	218.36	218.66	218.21	218.53	31727.0
2020-05-06 18:00:00	QQQ	ETF	218.53	218.9	218.01	218.24	112351.0
2020-05-06 19:00:00	QQQ	ETF	218.25	218.85	218.14	218.81	106558.0
2020-05-06 04:00:00	IWM	ETF	127.49	127.5	126.97	127.13	1500.0
2020-05-06 05:00:00	IWM	ETF	127.44	127.59	127.44	127.56	46050.0
2020-05-06 06:00:00	IWM	ETF	127.66	127.78	127.55	127.62	10555.0
2020-05-06 07:00:00	IWM	ETF	127.67	127.67	127.16	127.18	104980.0
2020-05-06 08:00:00	IWM	ETF	127.49	128.0	126.1	126.9	249700.0
2020-05-06 09:00:00	IWM	ETF	126.9	128.2	125.42	125.985	3435684.0
2020-05-06 10:00:00	IWM	ETF	125.99	127.34	125.32	126.71	4612255.0
2020-05-06 11:00:00	IWM	ETF	126.71	126.975	125.51	126.03	3075846.0
2020-05-06 12:00:00	IWM	ETF	126.01	126.955	125.86	126.69	2284939.0
2020-05-06 13:00:00	IWM	ETF	126.7	127.045	126.18	126.96	1750837.0
2020-05-06 14:00:00	IWM	ETF	126.95	127.1	126.35	126.8001	1987996.0
2020-05-06 15:00:00	IWM	ETF	126.82	126.91	125.0	125.6	5989004.0
2020-05-06 16:00:00	IWM	ETF	125.6	125.72	124.1033	125.1	1595864.0
2020-05-06 17:00:00	IWM	ETF	125.07	125.31	125.01	125.11	26154.0
2020-05-06 18:00:00	IWM	ETF	125.11	125.72	124.2	124.42	85072.0
2020-05-06 19:00:00	IWM	ETF	124.42	124.98	124.35	124.9	78614.0
2020-05-06 04:00:00	DIA	ETF	240.42	240.42	240.12	240.15	3779.0
2020-05-06 05:00:00	DIA	ETF	240.39	240.45	240.38	240.45	1851.0

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

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