PREVIEW / etf_1hour / 2019-12-24

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-12-24.parquet
  size:    218 KB
  rows:    6,925

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-24 04:00:00	SPY	ETF	321.47	321.59	321.47	321.57	1854.0
2019-12-24 05:00:00	SPY	ETF	321.57	321.6	321.52	321.55	2820.0
2019-12-24 06:00:00	SPY	ETF	321.55	321.6	321.54	321.6	4182.0
2019-12-24 07:00:00	SPY	ETF	321.571	321.75	321.57	321.64	11790.0
2019-12-24 08:00:00	SPY	ETF	321.62	321.7299	321.38	321.51	58930.0
2019-12-24 09:00:00	SPY	ETF	321.51	321.53	320.9	321.035	3548202.0
2019-12-24 10:00:00	SPY	ETF	321.04	321.29	321.02	321.1401	4219634.0
2019-12-24 11:00:00	SPY	ETF	321.155	321.28	321.12	321.145	4014843.0
2019-12-24 12:00:00	SPY	ETF	321.15	321.28	321.05	321.26	4335722.0
2019-12-24 13:00:00	SPY	ETF	321.24	321.34	321.17	321.2	1287078.0
2019-12-24 14:00:00	SPY	ETF	321.2	321.2499	321.18	321.2	17191.0
2019-12-24 15:00:00	SPY	ETF	321.26	321.27	321.16	321.16	3427.0
2019-12-24 16:00:00	SPY	ETF	321.25	321.28	321.2	321.24	6321.0
2019-12-24 04:00:00	QQQ	ETF	211.92	212.0	211.92	212.0	5600.0
2019-12-24 05:00:00	QQQ	ETF	212.0	212.02	211.97	211.99	4488.0
2019-12-24 06:00:00	QQQ	ETF	212.02	212.07	212.02	212.07	4400.0
2019-12-24 07:00:00	QQQ	ETF	212.05	212.12	212.0	212.03	16768.0
2019-12-24 08:00:00	QQQ	ETF	212.07	212.1	211.96	212.05	40124.0
2019-12-24 09:00:00	QQQ	ETF	212.05	212.09	211.44	211.65	1426062.0
2019-12-24 10:00:00	QQQ	ETF	211.64	211.85	211.64	211.76	1491044.0
2019-12-24 11:00:00	QQQ	ETF	211.77	211.91	211.75	211.85	654126.0
2019-12-24 12:00:00	QQQ	ETF	211.85	211.92	211.75	211.87	1336048.0
2019-12-24 13:00:00	QQQ	ETF	211.87	212.01	211.8082	211.875	709586.0
2019-12-24 14:00:00	QQQ	ETF	211.86	211.92	211.86	211.92	2852.0
2019-12-24 15:00:00	QQQ	ETF	211.8956	211.92	211.8956	211.92	436.0
2019-12-24 16:00:00	QQQ	ETF	211.9	211.95	211.9	211.95	800.0
2019-12-24 04:00:00	IWM	ETF	166.41	166.41	166.41	166.41	100.0
2019-12-24 05:00:00	IWM	ETF	166.36	166.36	166.36	166.36	100.0
2019-12-24 06:00:00	IWM	ETF	166.39	166.39	166.39	166.39	195.0
2019-12-24 07:00:00	IWM	ETF	166.36	166.42	166.36	166.39	4988.0
2019-12-24 08:00:00	IWM	ETF	166.4201	166.4201	166.3501	166.38	6885.0
2019-12-24 09:00:00	IWM	ETF	166.38	166.51	166.04	166.23	766910.0
2019-12-24 10:00:00	IWM	ETF	166.22	166.44	166.19	166.28	697715.0
2019-12-24 11:00:00	IWM	ETF	166.27	166.58	166.25	166.55	481821.0
2019-12-24 12:00:00	IWM	ETF	166.55	166.7	166.38	166.67	1131628.0
2019-12-24 13:00:00	IWM	ETF	166.66	166.8	166.52	166.67	302181.0
2019-12-24 14:00:00	IWM	ETF	166.67	166.67	166.61	166.61	1699.0
2019-12-24 15:00:00	IWM	ETF	166.68	166.68	166.61	166.61	7000.0
2019-12-24 06:00:00	DIA	ETF	285.57	285.57	285.57	285.57	177.0
2019-12-24 07:00:00	DIA	ETF	285.63	285.64	285.62	285.63	2853.0
2019-12-24 08:00:00	DIA	ETF	285.69	285.69	285.61	285.61	330.0
2019-12-24 09:00:00	DIA	ETF	285.62	285.63	284.95	285.16	113702.0
2019-12-24 10:00:00	DIA	ETF	285.18	285.25	285.03	285.07	96098.0
2019-12-24 11:00:00	DIA	ETF	285.06	285.21	284.97	284.97	81445.0
2019-12-24 12:00:00	DIA	ETF	284.98	285.04	284.87	285.03	214232.0
2019-12-24 13:00:00	DIA	ETF	285.01	285.1	284.98	285.0366	12823.0
2019-12-24 14:00:00	DIA	ETF	285.0	285.0	285.0	285.0	230.0
2019-12-24 15:00:00	DIA	ETF	285.08	285.08	285.08	285.08	100.0
2019-12-24 04:00:00	GLD	ETF	140.46	140.5	140.46	140.49	2900.0
2019-12-24 05:00:00	GLD	ETF	140.51	140.51	140.42	140.42	800.0

> showing 50 of 6,925 rows — these rows as CSV

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