PREVIEW / etf_1hour / 2019-01-09

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-01-09.parquet
  size:    327 KB
  rows:    10,844

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-01-09 04:00:00	SPY	ETF	257.5	257.77	257.3	257.54	42534.0
2019-01-09 05:00:00	SPY	ETF	257.47	257.62	257.01	257.34	49011.0
2019-01-09 06:00:00	SPY	ETF	257.42	257.49	256.9	257.29	83521.0
2019-01-09 07:00:00	SPY	ETF	257.17	257.45	256.75	257.38	303367.0
2019-01-09 08:00:00	SPY	ETF	257.41	257.8	256.77	257.71	1310163.0
2019-01-09 09:00:00	SPY	ETF	257.69	258.16	257.06	258.07	9910269.0
2019-01-09 10:00:00	SPY	ETF	258.07	258.29	256.19	256.94	15829210.0
2019-01-09 11:00:00	SPY	ETF	256.93	258.55	256.83	258.17	11411439.0
2019-01-09 12:00:00	SPY	ETF	258.15	258.8	257.9287	258.72	7199265.0
2019-01-09 13:00:00	SPY	ETF	258.71	258.77	257.89	258.17	6157964.0
2019-01-09 14:00:00	SPY	ETF	258.16	258.91	257.29	258.16	11856979.0
2019-01-09 15:00:00	SPY	ETF	258.17	258.61	257.29	257.88	16824751.0
2019-01-09 16:00:00	SPY	ETF	257.89	257.99	257.09	257.45	10916511.0
2019-01-09 17:00:00	SPY	ETF	257.33	257.53	257.21	257.26	1159764.0
2019-01-09 18:00:00	SPY	ETF	257.3	257.42	256.95	257.03	173057.0
2019-01-09 19:00:00	SPY	ETF	257.06	257.4	256.57	256.58	160793.0
2019-01-09 04:00:00	QQQ	ETF	160.0	160.28	159.97	160.14	99931.0
2019-01-09 05:00:00	QQQ	ETF	160.14	160.2	159.83	160.1	75282.0
2019-01-09 06:00:00	QQQ	ETF	160.21	160.21	159.81	160.07	18742.0
2019-01-09 07:00:00	QQQ	ETF	160.04	160.15	159.66	160.1	163722.0
2019-01-09 08:00:00	QQQ	ETF	160.04	160.38	159.67	160.18	320895.0
2019-01-09 09:00:00	QQQ	ETF	160.19	160.76	159.69	160.6	7147546.0
2019-01-09 10:00:00	QQQ	ETF	160.6	160.78	159.47	160.0231	7161531.0
2019-01-09 11:00:00	QQQ	ETF	160.02	161.1	159.9	160.84	4719955.0
2019-01-09 12:00:00	QQQ	ETF	160.83	161.25	160.69	161.2	3186873.0
2019-01-09 13:00:00	QQQ	ETF	161.2	161.28	160.78	160.9803	2437511.0
2019-01-09 14:00:00	QQQ	ETF	160.96	161.5229	160.241	161.0	5667517.0
2019-01-09 15:00:00	QQQ	ETF	161.0	161.32	160.35	160.78	6637558.0
2019-01-09 16:00:00	QQQ	ETF	160.8	160.85	160.27	160.5	2497389.0
2019-01-09 17:00:00	QQQ	ETF	160.53	160.54	160.27	160.4	31619.0
2019-01-09 18:00:00	QQQ	ETF	160.35	160.49	160.13	160.28	93514.0
2019-01-09 19:00:00	QQQ	ETF	160.28	160.51	159.87	159.87	66419.0
2019-01-09 04:00:00	IWM	ETF	142.0	142.0	142.0	142.0	950.0
2019-01-09 05:00:00	IWM	ETF	141.95	141.99	141.85	141.95	2100.0
2019-01-09 06:00:00	IWM	ETF	141.99	141.99	141.7	141.7	11117.0
2019-01-09 07:00:00	IWM	ETF	141.81	141.93	141.65	141.93	42214.0
2019-01-09 08:00:00	IWM	ETF	141.6901	142.32	141.6901	142.24	56295.0
2019-01-09 09:00:00	IWM	ETF	142.27	142.75	141.94	142.57	2517000.0
2019-01-09 10:00:00	IWM	ETF	142.57	142.88	141.62	141.89	3784744.0
2019-01-09 11:00:00	IWM	ETF	141.89	142.86	141.83	142.3	2686649.0
2019-01-09 12:00:00	IWM	ETF	142.3	142.95	142.3	142.9	1990020.0
2019-01-09 13:00:00	IWM	ETF	142.91	142.93	142.5	142.65	1327897.0
2019-01-09 14:00:00	IWM	ETF	142.63	143.21	142.44	143.14	2582345.0
2019-01-09 15:00:00	IWM	ETF	143.1331	143.39	142.68	142.9	4919205.0
2019-01-09 16:00:00	IWM	ETF	142.9	142.9981	142.37	142.5	567295.0
2019-01-09 17:00:00	IWM	ETF	142.41	142.65	142.37	142.4	708219.0
2019-01-09 18:00:00	IWM	ETF	142.42	142.9	142.35	142.4	73264.0
2019-01-09 19:00:00	IWM	ETF	142.28	142.33	142.09	142.09	6200.0
2019-01-09 04:00:00	DIA	ETF	238.56	238.88	238.56	238.88	1246.0
2019-01-09 05:00:00	DIA	ETF	238.32	238.32	238.32	238.32	100.0

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

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