PREVIEW / etf_1hour / 2018-09-13

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-09-13.parquet
  size:    302 KB
  rows:    9,889

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-09-13 04:00:00	SPY	ETF	289.31	289.6	289.31	289.46	15503.0
2018-09-13 05:00:00	SPY	ETF	289.5	289.56	289.27	289.36	16268.0
2018-09-13 06:00:00	SPY	ETF	289.36	289.79	289.36	289.65	32608.0
2018-09-13 07:00:00	SPY	ETF	289.65	289.97	289.62	289.92	110243.0
2018-09-13 08:00:00	SPY	ETF	289.9201	290.32	288.89	290.1	655992.0
2018-09-13 09:00:00	SPY	ETF	290.1	290.93	290.1	290.671	7166602.0
2018-09-13 10:00:00	SPY	ETF	290.675	291.0384	289.995	290.24	9752165.0
2018-09-13 11:00:00	SPY	ETF	290.24	290.78	290.022	290.78	5726884.0
2018-09-13 12:00:00	SPY	ETF	290.7825	290.98	290.62	290.73	3790241.0
2018-09-13 13:00:00	SPY	ETF	290.7327	290.79	290.5	290.56	3279139.0
2018-09-13 14:00:00	SPY	ETF	290.5601	290.89	290.38	290.88	4351611.0
2018-09-13 15:00:00	SPY	ETF	290.88	290.9	290.38	290.82	9687892.0
2018-09-13 16:00:00	SPY	ETF	290.82	290.96	289.22	290.83	5425015.0
2018-09-13 17:00:00	SPY	ETF	290.73	290.82	290.67	290.76	87990.0
2018-09-13 18:00:00	SPY	ETF	290.71	290.86	290.64	290.84	51328.0
2018-09-13 19:00:00	SPY	ETF	290.8	290.89	290.74	290.81	15216.0
2018-09-13 04:00:00	QQQ	ETF	182.68	182.81	182.68	182.77	5240.0
2018-09-13 05:00:00	QQQ	ETF	182.79	182.92	182.65	182.74	9665.0
2018-09-13 06:00:00	QQQ	ETF	182.73	183.15	182.73	183.06	22670.0
2018-09-13 07:00:00	QQQ	ETF	183.14	183.27	183.13	183.22	112440.0
2018-09-13 08:00:00	QQQ	ETF	183.22	183.65	182.25	183.43	574642.0
2018-09-13 09:00:00	QQQ	ETF	183.45	184.8	183.45	184.23	4670514.0
2018-09-13 10:00:00	QQQ	ETF	184.23	184.71	183.68	184.09	4231908.0
2018-09-13 11:00:00	QQQ	ETF	184.08	184.75	183.9	184.69	3362790.0
2018-09-13 12:00:00	QQQ	ETF	184.7	184.88	184.48	184.56	2645005.0
2018-09-13 13:00:00	QQQ	ETF	184.56	184.595	184.22	184.365	1715586.0
2018-09-13 14:00:00	QQQ	ETF	184.37	184.62	184.02	184.46	1894712.0
2018-09-13 15:00:00	QQQ	ETF	184.461	184.48	184.055	184.44	3582568.0
2018-09-13 16:00:00	QQQ	ETF	184.44	184.56	184.33	184.48	1654402.0
2018-09-13 17:00:00	QQQ	ETF	184.43	184.49	184.42	184.48	4527.0
2018-09-13 18:00:00	QQQ	ETF	184.43	184.58	184.38	184.5	11926.0
2018-09-13 19:00:00	QQQ	ETF	184.48	184.64	184.48	184.6	12815.0
2018-09-13 04:00:00	IWM	ETF	170.85	170.85	170.85	170.85	1000.0
2018-09-13 05:00:00	IWM	ETF	170.8	170.8	170.8	170.8	1000.0
2018-09-13 06:00:00	IWM	ETF	170.8	171.03	170.8	171.03	15200.0
2018-09-13 07:00:00	IWM	ETF	171.02	171.13	171.02	171.13	18404.0
2018-09-13 08:00:00	IWM	ETF	171.13	171.32	171.06	171.21	109254.0
2018-09-13 09:00:00	IWM	ETF	171.17	171.54	171.1	171.23	1691964.0
2018-09-13 10:00:00	IWM	ETF	171.24	171.32	170.38	170.56	3226050.0
2018-09-13 11:00:00	IWM	ETF	170.56	170.86	170.31	170.85	1280791.0
2018-09-13 12:00:00	IWM	ETF	170.85	171.03	170.78	170.93	907647.0
2018-09-13 13:00:00	IWM	ETF	170.929	170.95	170.519	170.52	730564.0
2018-09-13 14:00:00	IWM	ETF	170.52	170.75	170.41	170.6448	931955.0
2018-09-13 15:00:00	IWM	ETF	170.65	170.6654	170.26	170.6	2201223.0
2018-09-13 16:00:00	IWM	ETF	170.62	170.68	170.55	170.64	604007.0
2018-09-13 17:00:00	IWM	ETF	170.53	170.65	170.53	170.65	2432.0
2018-09-13 18:00:00	IWM	ETF	170.64	170.66	170.62	170.62	4332.0
2018-09-13 19:00:00	IWM	ETF	170.67	170.7	170.64	170.67	5732.0
2018-09-13 04:00:00	DIA	ETF	260.58	260.66	260.58	260.66	1500.0
2018-09-13 05:00:00	DIA	ETF	260.76	260.76	260.76	260.76	300.0

> showing 50 of 9,889 rows — these rows as CSV

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