PREVIEW / etf_1hour / 2018-08-13

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-08-13.parquet
  size:    305 KB
  rows:    10,085

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-08-13 04:00:00	SPY	ETF	282.24	283.15	282.14	282.61	36962.0
2018-08-13 05:00:00	SPY	ETF	282.75	282.84	282.48	282.48	16336.0
2018-08-13 06:00:00	SPY	ETF	282.51	282.79	282.39	282.58	34188.0
2018-08-13 07:00:00	SPY	ETF	282.58	283.4	282.58	283.3	219416.0
2018-08-13 08:00:00	SPY	ETF	282.7201	283.58	282.03	283.33	601604.0
2018-08-13 09:00:00	SPY	ETF	283.31	283.95	283.24	283.8985	4933231.0
2018-08-13 10:00:00	SPY	ETF	283.9	284.16	283.72	283.7838	5344706.0
2018-08-13 11:00:00	SPY	ETF	283.7875	283.91	282.42	282.42	8176500.0
2018-08-13 12:00:00	SPY	ETF	282.42	282.745	282.07	282.17	7229652.0
2018-08-13 13:00:00	SPY	ETF	282.16	282.78	281.77	282.45	6786421.0
2018-08-13 14:00:00	SPY	ETF	282.46	283.13	282.39	282.49	6812051.0
2018-08-13 15:00:00	SPY	ETF	282.49	282.79	281.94	282.05	14395524.0
2018-08-13 16:00:00	SPY	ETF	282.06	282.48	282.0125	282.35	8140342.0
2018-08-13 17:00:00	SPY	ETF	282.43	282.44	282.31	282.4	116987.0
2018-08-13 18:00:00	SPY	ETF	282.41	282.65	282.37	282.61	62026.0
2018-08-13 19:00:00	SPY	ETF	282.57	282.63	282.49	282.53	31236.0
2018-08-13 04:00:00	QQQ	ETF	179.94	180.12	179.75	180.1	11802.0
2018-08-13 05:00:00	QQQ	ETF	180.22	180.26	180.03	180.1	5000.0
2018-08-13 06:00:00	QQQ	ETF	180.07	180.3	180.03	180.14	24900.0
2018-08-13 07:00:00	QQQ	ETF	180.12	180.92	180.12	180.86	82050.0
2018-08-13 08:00:00	QQQ	ETF	180.86	181.13	179.63	180.88	378864.0
2018-08-13 09:00:00	QQQ	ETF	180.85	181.5627	180.76	181.5201	2848472.0
2018-08-13 10:00:00	QQQ	ETF	181.52	182.01	181.43	181.69	3298193.0
2018-08-13 11:00:00	QQQ	ETF	181.7	181.77	180.57	180.62	3424290.0
2018-08-13 12:00:00	QQQ	ETF	180.61	181.0	180.37	180.59	3161294.0
2018-08-13 13:00:00	QQQ	ETF	180.56	180.95	180.2574	180.74	2730065.0
2018-08-13 14:00:00	QQQ	ETF	180.74	181.19	180.58	180.66	2287786.0
2018-08-13 15:00:00	QQQ	ETF	180.63	180.88	180.241	180.36	4853990.0
2018-08-13 16:00:00	QQQ	ETF	180.35	180.62	180.32	180.52	1045460.0
2018-08-13 17:00:00	QQQ	ETF	180.63	180.63	180.47	180.47	1113.0
2018-08-13 18:00:00	QQQ	ETF	180.57	180.76	180.57	180.72	24110.0
2018-08-13 19:00:00	QQQ	ETF	180.71	180.79	180.62	180.68	16400.0
2018-08-13 04:00:00	IWM	ETF	167.09	167.09	167.09	167.09	250.0
2018-08-13 05:00:00	IWM	ETF	167.03	167.1	167.03	167.03	1400.0
2018-08-13 06:00:00	IWM	ETF	166.9	167.13	166.9	167.02	6000.0
2018-08-13 07:00:00	IWM	ETF	167.06	167.51	167.05	167.5	26563.0
2018-08-13 08:00:00	IWM	ETF	167.51	167.68	166.63	167.64	48871.0
2018-08-13 09:00:00	IWM	ETF	167.6	167.8	167.31	167.45	2114196.0
2018-08-13 10:00:00	IWM	ETF	167.46	168.05	167.4	167.66	1635383.0
2018-08-13 11:00:00	IWM	ETF	167.65	167.76	166.68	166.69	2220561.0
2018-08-13 12:00:00	IWM	ETF	166.685	166.76	166.1	166.155	2380583.0
2018-08-13 13:00:00	IWM	ETF	166.15	166.43	165.88	166.33	2059996.0
2018-08-13 14:00:00	IWM	ETF	166.33	167.2	166.3	166.94	1616489.0
2018-08-13 15:00:00	IWM	ETF	166.94	166.95	166.51	166.58	3457923.0
2018-08-13 16:00:00	IWM	ETF	166.56	166.81	166.4883	166.6	2050379.0
2018-08-13 17:00:00	IWM	ETF	166.72	166.8	166.72	166.8	200.0
2018-08-13 18:00:00	IWM	ETF	166.71	166.85	166.71	166.85	550.0
2018-08-13 19:00:00	IWM	ETF	166.85	166.85	166.78	166.78	700.0
2018-08-13 06:00:00	DIA	ETF	252.56	252.56	252.56	252.56	100.0
2018-08-13 07:00:00	DIA	ETF	252.83	253.01	252.83	253.01	348.0

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

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