PREVIEW / etf_1hour / 2018-03-26

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-03-26.parquet
  size:    308 KB
  rows:    10,103

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
2018-03-26 04:00:00	SPY	ETF	261.35	262.18	260.25	261.7	74523.0
2018-03-26 05:00:00	SPY	ETF	261.63	262.6	261.52	262.42	63840.0
2018-03-26 06:00:00	SPY	ETF	262.46	262.5	261.88	262.2	192113.0
2018-03-26 07:00:00	SPY	ETF	262.22	262.75	261.87	262.12	519311.0
2018-03-26 08:00:00	SPY	ETF	262.15	262.95	261.95	262.09	1006167.0
2018-03-26 09:00:00	SPY	ETF	262.06	263.17	261.76	262.63	13304591.0
2018-03-26 10:00:00	SPY	ETF	262.63	262.95	260.83	261.09	21412820.0
2018-03-26 11:00:00	SPY	ETF	261.08	261.35	259.41	261.0011	17074751.0
2018-03-26 12:00:00	SPY	ETF	261.0	262.37	260.57	261.4	14755263.0
2018-03-26 13:00:00	SPY	ETF	261.4	262.58	261.355	262.02	11273348.0
2018-03-26 14:00:00	SPY	ETF	262.02	264.05	261.98	263.59	12952541.0
2018-03-26 15:00:00	SPY	ETF	263.59	265.43	263.52	265.17	26842665.0
2018-03-26 16:00:00	SPY	ETF	265.15	265.23	261.3177	262.5876	18453246.0
2018-03-26 17:00:00	SPY	ETF	265.07	265.13	264.95	265.04	500861.0
2018-03-26 18:00:00	SPY	ETF	265.07	265.41	265.04	265.19	108926.0
2018-03-26 19:00:00	SPY	ETF	265.2	265.38	261.975	265.33	582029.0
2018-03-26 04:00:00	QQQ	ETF	159.75	161.58	159.75	161.36	39732.0
2018-03-26 05:00:00	QQQ	ETF	161.3	162.01	161.21	161.94	65913.0
2018-03-26 06:00:00	QQQ	ETF	161.94	161.94	161.43	161.7	121249.0
2018-03-26 07:00:00	QQQ	ETF	161.71	162.06	161.56	161.74	232337.0
2018-03-26 08:00:00	QQQ	ETF	161.71	162.23	161.615	161.63	408179.0
2018-03-26 09:00:00	QQQ	ETF	161.62	162.31	161.42	161.93	7227333.0
2018-03-26 10:00:00	QQQ	ETF	161.91	162.2	160.52	160.79	8358395.0
2018-03-26 11:00:00	QQQ	ETF	160.795	161.05	159.16	160.7	6725709.0
2018-03-26 12:00:00	QQQ	ETF	160.7	161.605	160.26	161.09	4452635.0
2018-03-26 13:00:00	QQQ	ETF	161.08	162.13	161.04	161.57	3874884.0
2018-03-26 14:00:00	QQQ	ETF	161.58	163.38	161.51	162.9593	5636760.0
2018-03-26 15:00:00	QQQ	ETF	162.97	164.6	162.9	164.42	8034775.0
2018-03-26 16:00:00	QQQ	ETF	164.41	164.55	162.2082	162.2082	6276286.0
2018-03-26 17:00:00	QQQ	ETF	164.56	164.56	164.4	164.5	31614.0
2018-03-26 18:00:00	QQQ	ETF	164.5	164.77	164.49	164.64	47491.0
2018-03-26 19:00:00	QQQ	ETF	164.68	164.76	164.4	164.75	30342.0
2018-03-26 04:00:00	IWM	ETF	151.99	152.25	151.99	152.12	22583.0
2018-03-26 05:00:00	IWM	ETF	152.19	152.49	152.17	152.47	7851.0
2018-03-26 06:00:00	IWM	ETF	152.52	152.52	152.25	152.48	52595.0
2018-03-26 07:00:00	IWM	ETF	152.41	152.57	152.18	152.4	96908.0
2018-03-26 08:00:00	IWM	ETF	152.41	152.79	152.11	152.11	236133.0
2018-03-26 09:00:00	IWM	ETF	152.09	152.44	151.45	151.87	3649640.0
2018-03-26 10:00:00	IWM	ETF	151.87	152.03	150.96	151.14	3146094.0
2018-03-26 11:00:00	IWM	ETF	151.13	151.33	150.43	151.13	2464337.0
2018-03-26 12:00:00	IWM	ETF	151.13	151.61	150.57	150.6	2224524.0
2018-03-26 13:00:00	IWM	ETF	150.59	151.42	150.57	151.4132	2010252.0
2018-03-26 14:00:00	IWM	ETF	151.41	152.57	151.34	152.28	3037100.0
2018-03-26 15:00:00	IWM	ETF	152.28	153.38	152.25	153.34	4821309.0
2018-03-26 16:00:00	IWM	ETF	153.33	153.34	150.593	153.225	2100034.0
2018-03-26 17:00:00	IWM	ETF	153.3	153.3	152.97	153.27	21888.0
2018-03-26 18:00:00	IWM	ETF	153.3	153.52	153.3	153.4	8862.0
2018-03-26 19:00:00	IWM	ETF	153.33	153.5	153.12	153.5	14681.0
2018-03-26 04:00:00	DIA	ETF	238.49	238.49	238.49	238.49	121.0
2018-03-26 05:00:00	DIA	ETF	238.4	238.4	238.4	238.4	1040.0

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

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