PREVIEW / etf_1hour / 2020-01-17

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-01-17.parquet
  size:    355 KB
  rows:    11,730

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-01-17 04:00:00	SPY	ETF	331.4	331.59	331.4	331.59	5971.0
2020-01-17 05:00:00	SPY	ETF	331.69	331.89	331.6	331.6	8080.0
2020-01-17 06:00:00	SPY	ETF	331.63	331.69	331.51	331.66	21709.0
2020-01-17 07:00:00	SPY	ETF	331.65	331.69	331.44	331.52	124350.0
2020-01-17 08:00:00	SPY	ETF	331.61	332.02	330.93	331.67	452022.0
2020-01-17 09:00:00	SPY	ETF	331.68	331.84	331.18	331.675	5549874.0
2020-01-17 10:00:00	SPY	ETF	331.67	331.82	331.31	331.48	8881314.0
2020-01-17 11:00:00	SPY	ETF	331.48	331.64	331.07	331.55	11338112.0
2020-01-17 12:00:00	SPY	ETF	331.55	331.82	331.4675	331.525	7510671.0
2020-01-17 13:00:00	SPY	ETF	331.53	331.79	331.5	331.66	3609549.0
2020-01-17 14:00:00	SPY	ETF	331.66	331.79	331.49	331.7175	6333366.0
2020-01-17 15:00:00	SPY	ETF	331.7101	332.18	331.3	332.01	19146759.0
2020-01-17 16:00:00	SPY	ETF	331.99	332.1316	331.5	331.53	19281394.0
2020-01-17 17:00:00	SPY	ETF	331.53	331.95	331.5	331.6	1158748.0
2020-01-17 18:00:00	SPY	ETF	331.58	331.89	331.58	331.7	47174.0
2020-01-17 19:00:00	SPY	ETF	331.7	331.75	331.55	331.6	9491.0
2020-01-17 04:00:00	QQQ	ETF	222.68	222.96	222.68	222.92	21026.0
2020-01-17 05:00:00	QQQ	ETF	222.96	223.11	222.94	223.02	11580.0
2020-01-17 06:00:00	QQQ	ETF	223.04	223.11	222.98	223.07	17175.0
2020-01-17 07:00:00	QQQ	ETF	223.08	223.09	222.87	222.96	65342.0
2020-01-17 08:00:00	QQQ	ETF	223.02	223.33	222.28	223.19	253856.0
2020-01-17 09:00:00	QQQ	ETF	223.19	223.44	222.37	222.81	2767152.0
2020-01-17 10:00:00	QQQ	ETF	222.81	222.96	222.48	222.55	1894183.0
2020-01-17 11:00:00	QQQ	ETF	222.57	222.72	222.1221	222.52	1990044.0
2020-01-17 12:00:00	QQQ	ETF	222.53	222.79	222.43	222.53	1134459.0
2020-01-17 13:00:00	QQQ	ETF	222.53	222.87	222.52	222.84	959157.0
2020-01-17 14:00:00	QQQ	ETF	222.84	222.93	222.6434	222.825	940170.0
2020-01-17 15:00:00	QQQ	ETF	222.83	223.56	222.5345	223.41	4671926.0
2020-01-17 16:00:00	QQQ	ETF	223.39	223.4755	223.07	223.09	994675.0
2020-01-17 17:00:00	QQQ	ETF	223.09	223.38	223.09	223.19	581810.0
2020-01-17 18:00:00	QQQ	ETF	223.23	223.23	223.12	223.2	1301.0
2020-01-17 19:00:00	QQQ	ETF	223.2	223.28	223.2	223.23	14288.0
2020-01-17 04:00:00	IWM	ETF	169.97	170.0	169.97	170.0	1234.0
2020-01-17 05:00:00	IWM	ETF	170.05	170.05	170.05	170.05	999.0
2020-01-17 06:00:00	IWM	ETF	170.04	170.11	170.01	170.1	4635.0
2020-01-17 07:00:00	IWM	ETF	170.09	170.11	169.97	169.97	24575.0
2020-01-17 08:00:00	IWM	ETF	170.08	170.32	169.98	170.07	210486.0
2020-01-17 09:00:00	IWM	ETF	170.1	170.36	169.55	169.71	1791426.0
2020-01-17 10:00:00	IWM	ETF	169.7	169.75	169.075	169.19	2144008.0
2020-01-17 11:00:00	IWM	ETF	169.2	169.5	168.94	169.46	1482909.0
2020-01-17 12:00:00	IWM	ETF	169.47	169.57	169.2	169.3661	1025985.0
2020-01-17 13:00:00	IWM	ETF	169.37	169.48	169.16	169.2	486413.0
2020-01-17 14:00:00	IWM	ETF	169.2	169.23	168.825	169.0	1851891.0
2020-01-17 15:00:00	IWM	ETF	169.0	169.06	168.67	169.01	2829709.0
2020-01-17 16:00:00	IWM	ETF	169.01	169.07	168.71	168.76	847419.0
2020-01-17 17:00:00	IWM	ETF	168.82	169.07	168.73	168.84	386700.0
2020-01-17 18:00:00	IWM	ETF	168.88	168.88	168.84	168.84	1820.0
2020-01-17 19:00:00	IWM	ETF	168.84	168.84	168.84	168.84	878.0
2020-01-17 04:00:00	DIA	ETF	293.27	293.48	293.27	293.48	741.0
2020-01-17 07:00:00	DIA	ETF	293.52	293.52	293.3	293.3	7700.0

> showing 50 of 11,730 rows — these rows as CSV

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