PREVIEW / etf_1hour / 2019-12-26

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-12-26.parquet
  size:    336 KB
  rows:    11,135

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-26 04:00:00	SPY	ETF	321.54	321.79	321.54	321.76	8326.0
2019-12-26 05:00:00	SPY	ETF	321.79	321.8	321.77	321.77	1900.0
2019-12-26 06:00:00	SPY	ETF	321.77	321.77	321.75	321.75	600.0
2019-12-26 07:00:00	SPY	ETF	321.75	321.78	321.7	321.76	18799.0
2019-12-26 08:00:00	SPY	ETF	321.76	321.97	321.65	321.8	193442.0
2019-12-26 09:00:00	SPY	ETF	321.75	322.14	321.64	321.985	2322259.0
2019-12-26 10:00:00	SPY	ETF	321.99	322.355	321.98	322.29	4335004.0
2019-12-26 11:00:00	SPY	ETF	322.29	322.47	322.2	322.285	3994345.0
2019-12-26 12:00:00	SPY	ETF	322.28	322.29	321.99	322.2	2871755.0
2019-12-26 13:00:00	SPY	ETF	322.2099	322.39	322.17	322.34	2270502.0
2019-12-26 14:00:00	SPY	ETF	322.34	322.44	322.19	322.2	1971664.0
2019-12-26 15:00:00	SPY	ETF	322.2	322.93	322.02	322.91	9416468.0
2019-12-26 16:00:00	SPY	ETF	322.9	323.14	322.83	322.89	2745103.0
2019-12-26 17:00:00	SPY	ETF	322.86	322.94	322.86	322.93	17595.0
2019-12-26 18:00:00	SPY	ETF	322.93	323.03	322.88	323.0	67867.0
2019-12-26 19:00:00	SPY	ETF	323.0	323.39	322.95	323.39	100212.0
2019-12-26 04:00:00	QQQ	ETF	212.1	212.28	212.1	212.27	7900.0
2019-12-26 05:00:00	QQQ	ETF	212.27	212.28	212.25	212.27	1200.0
2019-12-26 06:00:00	QQQ	ETF	212.28	212.33	212.25	212.25	5743.0
2019-12-26 07:00:00	QQQ	ETF	212.25	212.29	212.21	212.29	12470.0
2019-12-26 08:00:00	QQQ	ETF	212.23	212.48	212.2	212.35	89573.0
2019-12-26 09:00:00	QQQ	ETF	212.31	212.77	212.23	212.68	1710254.0
2019-12-26 10:00:00	QQQ	ETF	212.68	212.97	212.68	212.94	1188116.0
2019-12-26 11:00:00	QQQ	ETF	212.94	213.25	212.94	213.2	1223459.0
2019-12-26 12:00:00	QQQ	ETF	213.2	213.21	212.91	213.14	1042905.0
2019-12-26 13:00:00	QQQ	ETF	213.14	213.495	213.14	213.46	902503.0
2019-12-26 14:00:00	QQQ	ETF	213.465	213.53	213.36	213.41	859642.0
2019-12-26 15:00:00	QQQ	ETF	213.41	213.81	213.22	213.78	3349441.0
2019-12-26 16:00:00	QQQ	ETF	213.8	213.88	213.4726	213.79	2589735.0
2019-12-26 17:00:00	QQQ	ETF	213.82	213.84	213.75	213.75	11342.0
2019-12-26 18:00:00	QQQ	ETF	213.77	213.97	213.77	213.94	23409.0
2019-12-26 19:00:00	QQQ	ETF	213.93	214.25	213.91	214.22	66630.0
2019-12-26 04:00:00	IWM	ETF	166.93	166.94	166.93	166.94	300.0
2019-12-26 07:00:00	IWM	ETF	166.83	166.85	166.82	166.85	8800.0
2019-12-26 08:00:00	IWM	ETF	166.88	167.01	166.79	166.86	17485.0
2019-12-26 09:00:00	IWM	ETF	166.88	166.98	166.665	166.775	628437.0
2019-12-26 10:00:00	IWM	ETF	166.775	166.89	166.7	166.79	854117.0
2019-12-26 11:00:00	IWM	ETF	166.7944	166.8992	166.57	166.6035	877993.0
2019-12-26 12:00:00	IWM	ETF	166.605	166.62	166.37	166.475	670135.0
2019-12-26 13:00:00	IWM	ETF	166.47	166.69	166.47	166.65	475195.0
2019-12-26 14:00:00	IWM	ETF	166.65	166.69	166.52	166.54	493797.0
2019-12-26 15:00:00	IWM	ETF	166.54	166.71	166.36	166.69	2098465.0
2019-12-26 16:00:00	IWM	ETF	166.69	166.82	166.63	166.72	1611075.0
2019-12-26 17:00:00	IWM	ETF	166.77	166.77	166.68	166.68	32779.0
2019-12-26 18:00:00	IWM	ETF	166.78	166.78	166.75	166.77	7400.0
2019-12-26 19:00:00	IWM	ETF	166.78	166.93	166.78	166.92	9335.0
2019-12-26 07:00:00	DIA	ETF	285.24	285.3	285.22	285.3	700.0
2019-12-26 08:00:00	DIA	ETF	285.3	285.3	285.3	285.3	100.0
2019-12-26 09:00:00	DIA	ETF	285.2207	285.61	285.2	285.4049	95296.0
2019-12-26 10:00:00	DIA	ETF	285.43	285.6	285.35	285.54	52972.0

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

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