PREVIEW / etf_1hour / 2018-10-24

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-10-24.parquet
  size:    326 KB
  rows:    10,717

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-10-24 04:00:00	SPY	ETF	272.42	272.45	271.42	271.48	119109.0
2018-10-24 05:00:00	SPY	ETF	271.46	272.31	271.41	272.29	110848.0
2018-10-24 06:00:00	SPY	ETF	272.21	272.65	272.15	272.65	190423.0
2018-10-24 07:00:00	SPY	ETF	272.66	274.03	272.49	273.96	869155.0
2018-10-24 08:00:00	SPY	ETF	272.61	274.11	272.0	273.67	939050.0
2018-10-24 09:00:00	SPY	ETF	273.65	273.76	272.54	272.7701	8747516.0
2018-10-24 10:00:00	SPY	ETF	272.78	273.12	271.49	271.53	14480142.0
2018-10-24 11:00:00	SPY	ETF	271.54	272.2776	269.81	271.995	23283573.0
2018-10-24 12:00:00	SPY	ETF	271.99	272.16	270.31	271.01	10696990.0
2018-10-24 13:00:00	SPY	ETF	271.02	271.02	269.17	269.49	14144316.0
2018-10-24 14:00:00	SPY	ETF	269.49	270.61	268.71	269.2	19767526.0
2018-10-24 15:00:00	SPY	ETF	269.215	269.215	264.7	265.22	55745585.0
2018-10-24 16:00:00	SPY	ETF	265.25	269.3	265.08	266.88	21282286.0
2018-10-24 17:00:00	SPY	ETF	266.89	266.9	265.32	266.79	3994427.0
2018-10-24 18:00:00	SPY	ETF	266.8	266.82	265.32	266.62	728597.0
2018-10-24 19:00:00	SPY	ETF	266.66	266.83	265.3	265.69	282311.0
2018-10-24 20:00:00	SPY	ETF	265.32	265.75	265.32	265.75	300.0
2018-10-24 04:00:00	QQQ	ETF	172.5	172.5	171.52	171.59	68993.0
2018-10-24 05:00:00	QQQ	ETF	171.49	172.19	171.47	172.05	38851.0
2018-10-24 06:00:00	QQQ	ETF	172.0	172.48	172.0	172.4	51396.0
2018-10-24 07:00:00	QQQ	ETF	172.49	173.69	172.39	173.69	365547.0
2018-10-24 08:00:00	QQQ	ETF	173.27	173.85	172.0	173.55	550022.0
2018-10-24 09:00:00	QQQ	ETF	173.52	173.62	171.99	172.36	7277311.0
2018-10-24 10:00:00	QQQ	ETF	172.37	172.87	171.52	171.56	7432876.0
2018-10-24 11:00:00	QQQ	ETF	171.56	171.73	169.8	171.5	12282463.0
2018-10-24 12:00:00	QQQ	ETF	171.49	171.59	170.16	170.72	6312915.0
2018-10-24 13:00:00	QQQ	ETF	170.725	170.725	168.84	168.99	10154861.0
2018-10-24 14:00:00	QQQ	ETF	168.99	169.64	168.4	168.71	12422026.0
2018-10-24 15:00:00	QQQ	ETF	168.71	168.71	165.04	165.34	28048560.0
2018-10-24 16:00:00	QQQ	ETF	165.33	167.29	165.22	167.23	6415163.0
2018-10-24 17:00:00	QQQ	ETF	167.28	167.3	165.34	166.99	411669.0
2018-10-24 18:00:00	QQQ	ETF	167.19	167.34	165.34	167.04	1115596.0
2018-10-24 19:00:00	QQQ	ETF	167.04	167.15	165.84	166.12	157776.0
2018-10-24 04:00:00	IWM	ETF	151.0	151.0	150.53	150.53	1400.0
2018-10-24 05:00:00	IWM	ETF	150.88	151.06	150.88	151.06	10235.0
2018-10-24 06:00:00	IWM	ETF	151.01	151.05	150.92	150.92	2700.0
2018-10-24 07:00:00	IWM	ETF	151.19	151.9	151.19	151.89	75554.0
2018-10-24 08:00:00	IWM	ETF	151.5101	151.95	151.05	151.73	79866.0
2018-10-24 09:00:00	IWM	ETF	151.68	151.98	151.25	151.68	2222127.0
2018-10-24 10:00:00	IWM	ETF	151.67	151.67	150.39	150.43	3376662.0
2018-10-24 11:00:00	IWM	ETF	150.42	150.75	149.46	150.59	4802987.0
2018-10-24 12:00:00	IWM	ETF	150.59	150.63	149.03	149.505	2706531.0
2018-10-24 13:00:00	IWM	ETF	149.48	149.48	148.41	148.73	4169527.0
2018-10-24 14:00:00	IWM	ETF	148.719	148.98	147.95	148.0	4282151.0
2018-10-24 15:00:00	IWM	ETF	147.995	148.01	145.82	145.9	8748614.0
2018-10-24 16:00:00	IWM	ETF	145.9419	146.6801	145.74	146.6801	1659345.0
2018-10-24 17:00:00	IWM	ETF	146.37	146.69	145.95	146.6001	470521.0
2018-10-24 18:00:00	IWM	ETF	146.68	146.96	145.95	146.96	165140.0
2018-10-24 19:00:00	IWM	ETF	147.0	147.02	146.09	146.29	13427.0
2018-10-24 04:00:00	DIA	ETF	250.86	250.86	250.76	250.76	501.0

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

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