PREVIEW / etf_1hour / 2020-01-14

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-01-14.parquet
  size:    360 KB
  rows:    11,902

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-14 04:00:00	SPY	ETF	327.31	328.34	327.31	328.16	19262.0
2020-01-14 05:00:00	SPY	ETF	328.14	328.22	327.5	327.73	24978.0
2020-01-14 06:00:00	SPY	ETF	327.7	327.82	327.24	327.76	36976.0
2020-01-14 07:00:00	SPY	ETF	327.83	327.98	327.69	327.77	80481.0
2020-01-14 08:00:00	SPY	ETF	327.7901	328.06	326.76	327.95	192881.0
2020-01-14 09:00:00	SPY	ETF	327.95	327.97	327.06	327.13	6640960.0
2020-01-14 10:00:00	SPY	ETF	327.135	327.8	327.04	327.55	7325675.0
2020-01-14 11:00:00	SPY	ETF	327.55	327.98	327.5	327.97	2791824.0
2020-01-14 12:00:00	SPY	ETF	327.975	328.4	327.9	328.29	2631710.0
2020-01-14 13:00:00	SPY	ETF	328.29	328.62	327.39	327.61	9380931.0
2020-01-14 14:00:00	SPY	ETF	327.62	328.06	326.844	327.59	11623668.0
2020-01-14 15:00:00	SPY	ETF	327.59	327.9774	326.98	327.43	13520010.0
2020-01-14 16:00:00	SPY	ETF	327.42	327.94	327.152	327.89	5851080.0
2020-01-14 17:00:00	SPY	ETF	327.92	327.92	327.45	327.9	702693.0
2020-01-14 18:00:00	SPY	ETF	327.85	327.85	327.01	327.01	180576.0
2020-01-14 19:00:00	SPY	ETF	327.05	327.34	326.93	327.23	67249.0
2020-01-14 04:00:00	QQQ	ETF	220.6	221.21	220.51	221.13	53862.0
2020-01-14 05:00:00	QQQ	ETF	221.11	221.22	220.5	220.75	58563.0
2020-01-14 06:00:00	QQQ	ETF	220.75	220.87	220.41	220.6	30190.0
2020-01-14 07:00:00	QQQ	ETF	220.7	220.96	220.59	220.84	118098.0
2020-01-14 08:00:00	QQQ	ETF	221.1	221.17	220.02	221.0	203778.0
2020-01-14 09:00:00	QQQ	ETF	221.05	221.05	219.77	219.8829	3131914.0
2020-01-14 10:00:00	QQQ	ETF	219.89	220.83	219.74	220.36	3147276.0
2020-01-14 11:00:00	QQQ	ETF	220.35	220.77	220.26	220.76	1234373.0
2020-01-14 12:00:00	QQQ	ETF	220.76	221.07	220.66	220.83	1604488.0
2020-01-14 13:00:00	QQQ	ETF	220.83	221.21	220.18	220.26	3784763.0
2020-01-14 14:00:00	QQQ	ETF	220.2777	220.77	219.75	220.34	3104138.0
2020-01-14 15:00:00	QQQ	ETF	220.33	220.4509	219.76	220.1	4136300.0
2020-01-14 16:00:00	QQQ	ETF	220.08	220.42	220.04	220.41	871845.0
2020-01-14 17:00:00	QQQ	ETF	220.4	220.44	220.3	220.33	507196.0
2020-01-14 18:00:00	QQQ	ETF	220.38	220.4	219.61	219.61	76219.0
2020-01-14 19:00:00	QQQ	ETF	219.64	219.93	219.54	219.76	89409.0
2020-01-14 04:00:00	IWM	ETF	165.58	165.72	165.58	165.7	8400.0
2020-01-14 05:00:00	IWM	ETF	165.81	165.81	165.81	165.81	2500.0
2020-01-14 06:00:00	IWM	ETF	165.28	165.57	165.28	165.56	6668.0
2020-01-14 07:00:00	IWM	ETF	165.57	165.72	165.5	165.55	26867.0
2020-01-14 08:00:00	IWM	ETF	165.5501	165.81	165.49	165.7	37430.0
2020-01-14 09:00:00	IWM	ETF	165.72	165.72	164.98	165.2	1743406.0
2020-01-14 10:00:00	IWM	ETF	165.2199	165.93	165.14	165.81	1918000.0
2020-01-14 11:00:00	IWM	ETF	165.81	166.545	165.81	166.48	1547811.0
2020-01-14 12:00:00	IWM	ETF	166.47	167.35	166.395	167.29	1668019.0
2020-01-14 13:00:00	IWM	ETF	167.3	167.59	166.62	166.63	3237842.0
2020-01-14 14:00:00	IWM	ETF	166.64	166.94	166.09	166.56	2551094.0
2020-01-14 15:00:00	IWM	ETF	166.55	166.725	166.315	166.595	2354428.0
2020-01-14 16:00:00	IWM	ETF	166.595	166.88	166.51	166.69	578630.0
2020-01-14 17:00:00	IWM	ETF	166.78	166.78	166.57	166.68	130971.0
2020-01-14 18:00:00	IWM	ETF	166.66	166.66	166.19	166.27	28891.0
2020-01-14 19:00:00	IWM	ETF	166.18	166.19	166.18	166.19	213.0
2020-01-14 04:00:00	DIA	ETF	288.5	288.5	288.49	288.49	200.0
2020-01-14 05:00:00	DIA	ETF	288.9	288.9	288.9	288.9	100.0

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

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