PREVIEW / etf_1hour / 2019-01-08

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-01-08.parquet
  size:    325 KB
  rows:    10,869

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-01-08 04:00:00	SPY	ETF	255.4	256.15	254.52	255.42	66489.0
2019-01-08 05:00:00	SPY	ETF	255.37	255.92	255.28	255.87	41712.0
2019-01-08 06:00:00	SPY	ETF	255.83	256.43	255.68	256.21	196760.0
2019-01-08 07:00:00	SPY	ETF	256.25	256.39	255.57	255.92	445286.0
2019-01-08 08:00:00	SPY	ETF	255.9	256.65	254.565	256.61	1747828.0
2019-01-08 09:00:00	SPY	ETF	256.59	257.31	255.98	256.22	12842188.0
2019-01-08 10:00:00	SPY	ETF	256.22	256.71	254.0	254.49	20061360.0
2019-01-08 11:00:00	SPY	ETF	254.48	255.3799	254.31	255.29	11671029.0
2019-01-08 12:00:00	SPY	ETF	255.3	256.06	254.71	255.2	10316303.0
2019-01-08 13:00:00	SPY	ETF	255.21	256.47	254.91	256.21	8878851.0
2019-01-08 14:00:00	SPY	ETF	256.22	256.59	255.92	256.24	7639808.0
2019-01-08 15:00:00	SPY	ETF	256.24	256.94	255.8	256.69	19467139.0
2019-01-08 16:00:00	SPY	ETF	256.7	256.82	256.21	256.28	7299490.0
2019-01-08 17:00:00	SPY	ETF	256.27	256.6	256.25	256.26	646883.0
2019-01-08 18:00:00	SPY	ETF	256.25	256.99	256.2	256.96	288192.0
2019-01-08 19:00:00	SPY	ETF	256.84	257.2	256.78	256.89	158318.0
2019-01-08 04:00:00	QQQ	ETF	158.78	159.0	158.61	158.63	107197.0
2019-01-08 05:00:00	QQQ	ETF	158.59	158.96	158.45	158.95	25825.0
2019-01-08 06:00:00	QQQ	ETF	158.85	159.33	158.77	159.25	26622.0
2019-01-08 07:00:00	QQQ	ETF	159.22	159.4	158.86	159.04	237558.0
2019-01-08 08:00:00	QQQ	ETF	159.3099	159.46	158.6	159.42	521929.0
2019-01-08 09:00:00	QQQ	ETF	159.42	160.11	158.87	159.012	7764914.0
2019-01-08 10:00:00	QQQ	ETF	159.01	159.4	157.2	157.6	9028090.0
2019-01-08 11:00:00	QQQ	ETF	157.605	158.54	157.54	158.4879	5263546.0
2019-01-08 12:00:00	QQQ	ETF	158.49	159.11	158.25	158.54	4515951.0
2019-01-08 13:00:00	QQQ	ETF	158.54	159.51	158.32	159.36	4103701.0
2019-01-08 14:00:00	QQQ	ETF	159.35	159.68	159.14	159.4	3559605.0
2019-01-08 15:00:00	QQQ	ETF	159.39	159.735	159.06	159.56	6139548.0
2019-01-08 16:00:00	QQQ	ETF	159.55	159.63	159.26	159.33	999348.0
2019-01-08 17:00:00	QQQ	ETF	159.25	159.46	159.2	159.31	17385.0
2019-01-08 18:00:00	QQQ	ETF	159.22	159.7	159.17	159.7	81802.0
2019-01-08 19:00:00	QQQ	ETF	159.65	159.89	159.61	159.7	77051.0
2019-01-08 04:00:00	IWM	ETF	140.02	140.21	140.02	140.21	400.0
2019-01-08 05:00:00	IWM	ETF	140.22	140.22	140.22	140.22	200.0
2019-01-08 06:00:00	IWM	ETF	140.25	140.51	140.23	140.51	2666.0
2019-01-08 07:00:00	IWM	ETF	140.56	140.57	140.04	140.04	7105.0
2019-01-08 08:00:00	IWM	ETF	140.45	140.7	140.15	140.68	39099.0
2019-01-08 09:00:00	IWM	ETF	140.68	141.16	140.18	140.29	3050437.0
2019-01-08 10:00:00	IWM	ETF	140.3	140.825	139.39	139.86	4132999.0
2019-01-08 11:00:00	IWM	ETF	139.87	140.98	139.78	140.98	2452487.0
2019-01-08 12:00:00	IWM	ETF	140.98	141.39	140.7035	141.0	2856763.0
2019-01-08 13:00:00	IWM	ETF	141.0	141.59	140.96	141.41	1965878.0
2019-01-08 14:00:00	IWM	ETF	141.4	141.5	141.14	141.28	1813684.0
2019-01-08 15:00:00	IWM	ETF	141.27	141.79	141.03	141.71	4077977.0
2019-01-08 16:00:00	IWM	ETF	141.7	141.82	141.31	141.31	2014797.0
2019-01-08 17:00:00	IWM	ETF	141.31	141.55	141.24	141.24	1858.0
2019-01-08 18:00:00	IWM	ETF	141.52	141.73	141.42	141.72	8334.0
2019-01-08 19:00:00	IWM	ETF	141.74	141.88	141.71	141.72	7000.0
2019-01-08 04:00:00	DIA	ETF	236.71	236.71	236.66	236.66	396.0
2019-01-08 05:00:00	DIA	ETF	236.4	236.64	236.35	236.6	2570.0

> showing 50 of 10,869 rows — these rows as CSV

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