PREVIEW / etf_1hour / 2019-11-29

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-11-29.parquet
  size:    212 KB
  rows:    6,725

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-11-29 04:00:00	SPY	ETF	314.8	314.89	314.74	314.87	9137.0
2019-11-29 05:00:00	SPY	ETF	314.83	314.87	314.73	314.79	5180.0
2019-11-29 06:00:00	SPY	ETF	314.76	314.9	314.76	314.79	12261.0
2019-11-29 07:00:00	SPY	ETF	314.81	315.03	314.81	315.01	36327.0
2019-11-29 08:00:00	SPY	ETF	314.8899	315.07	314.35	314.91	107902.0
2019-11-29 09:00:00	SPY	ETF	314.9	315.13	314.5869	314.975	4677230.0
2019-11-29 10:00:00	SPY	ETF	314.97	315.12	314.8	314.87	6326190.0
2019-11-29 11:00:00	SPY	ETF	314.865	314.885	314.42	314.75	3971639.0
2019-11-29 12:00:00	SPY	ETF	314.75	314.82	314.06	314.27	10126513.0
2019-11-29 13:00:00	SPY	ETF	314.27	314.76	314.26	314.47	3400562.0
2019-11-29 14:00:00	SPY	ETF	314.5	314.6	314.43	314.6	88516.0
2019-11-29 15:00:00	SPY	ETF	314.59	314.6	314.32	314.5	26987.0
2019-11-29 16:00:00	SPY	ETF	314.49	314.62	314.44	314.6	12817.0
2019-11-29 04:00:00	QQQ	ETF	205.6	205.65	205.5	205.59	12364.0
2019-11-29 05:00:00	QQQ	ETF	205.57	205.65	205.5	205.54	3842.0
2019-11-29 06:00:00	QQQ	ETF	205.58	205.73	205.55	205.67	4092.0
2019-11-29 07:00:00	QQQ	ETF	205.69	205.76	205.65	205.7	24451.0
2019-11-29 08:00:00	QQQ	ETF	205.7	205.78	205.26	205.58	46555.0
2019-11-29 09:00:00	QQQ	ETF	205.54	205.8	205.38	205.7701	1413809.0
2019-11-29 10:00:00	QQQ	ETF	205.76	205.83	205.45	205.59	1119923.0
2019-11-29 11:00:00	QQQ	ETF	205.5801	205.5944	205.27	205.53	1191038.0
2019-11-29 12:00:00	QQQ	ETF	205.53	205.54	205.0	205.08	2496313.0
2019-11-29 13:00:00	QQQ	ETF	205.06	205.4	205.0236	205.28	880187.0
2019-11-29 14:00:00	QQQ	ETF	205.2539	205.5	205.2	205.36	45216.0
2019-11-29 15:00:00	QQQ	ETF	205.37	205.38	205.2	205.2	13723.0
2019-11-29 16:00:00	QQQ	ETF	205.23	205.3	205.16	205.3	3547.0
2019-11-29 04:00:00	IWM	ETF	162.47	162.47	162.27	162.27	3250.0
2019-11-29 05:00:00	IWM	ETF	162.24	162.24	162.24	162.24	600.0
2019-11-29 06:00:00	IWM	ETF	162.29	162.29	162.29	162.29	500.0
2019-11-29 07:00:00	IWM	ETF	162.29	162.38	162.29	162.38	900.0
2019-11-29 08:00:00	IWM	ETF	162.34	162.49	162.06	162.42	27869.0
2019-11-29 09:00:00	IWM	ETF	162.4	162.48	161.71	162.37	1207802.0
2019-11-29 10:00:00	IWM	ETF	162.37	162.795	162.2	162.5099	1288879.0
2019-11-29 11:00:00	IWM	ETF	162.49	162.535	162.14	162.51	1285607.0
2019-11-29 12:00:00	IWM	ETF	162.505	162.57	161.67	161.71	3095500.0
2019-11-29 13:00:00	IWM	ETF	161.72	162.05	161.69	162.0018	1461449.0
2019-11-29 14:00:00	IWM	ETF	162.01	162.1	161.77	161.91	105664.0
2019-11-29 15:00:00	IWM	ETF	161.92	161.97	161.92	161.97	2800.0
2019-11-29 16:00:00	IWM	ETF	161.91	161.91	161.81	161.81	6806.0
2019-11-29 04:00:00	DIA	ETF	281.35	281.35	281.35	281.35	300.0
2019-11-29 07:00:00	DIA	ETF	281.42	281.53	281.42	281.49	500.0
2019-11-29 08:00:00	DIA	ETF	281.48	281.48	281.16	281.4199	10600.0
2019-11-29 09:00:00	DIA	ETF	281.36	281.44	281.0643	281.34	215300.0
2019-11-29 10:00:00	DIA	ETF	281.31	281.57	281.28	281.39	119323.0
2019-11-29 11:00:00	DIA	ETF	281.38	281.39	281.02	281.24	90792.0
2019-11-29 12:00:00	DIA	ETF	281.23	281.38	280.84	281.02	272974.0
2019-11-29 13:00:00	DIA	ETF	281.03	281.66	280.84	281.05	42127.0
2019-11-29 14:00:00	DIA	ETF	281.05	281.05	281.04	281.04	260.0
2019-11-29 15:00:00	DIA	ETF	281.18	281.18	281.18	281.18	1000.0
2019-11-29 04:00:00	GLD	ETF	137.2	137.2	137.17	137.17	500.0

> showing 50 of 6,725 rows — these rows as CSV

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