PREVIEW / etf_1hour / 2019-01-30

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-01-30.parquet
  size:    326 KB
  rows:    10,753

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-30 04:00:00	SPY	ETF	264.4	264.41	263.97	264.22	25837.0
2019-01-30 05:00:00	SPY	ETF	264.3	264.35	264.09	264.3	40693.0
2019-01-30 06:00:00	SPY	ETF	264.26	264.5	264.24	264.47	36074.0
2019-01-30 07:00:00	SPY	ETF	264.47	265.02	264.44	264.77	199518.0
2019-01-30 08:00:00	SPY	ETF	264.26	264.91	263.4284	264.84	344266.0
2019-01-30 09:00:00	SPY	ETF	264.8	265.2475	264.47	264.56	7283327.0
2019-01-30 10:00:00	SPY	ETF	264.55	265.08	264.25	264.87	7587513.0
2019-01-30 11:00:00	SPY	ETF	264.88	265.84	264.87	265.8171	8450061.0
2019-01-30 12:00:00	SPY	ETF	265.82	266.29	265.68	265.78	6632168.0
2019-01-30 13:00:00	SPY	ETF	265.77	265.92	265.285	265.4525	4393379.0
2019-01-30 14:00:00	SPY	ETF	265.47	268.52	264.97	268.48	25730235.0
2019-01-30 15:00:00	SPY	ETF	268.49	268.49	267.0	267.59	22259737.0
2019-01-30 16:00:00	SPY	ETF	267.59	268.05	267.09	267.9	7390009.0
2019-01-30 17:00:00	SPY	ETF	267.81	268.05	267.77	267.97	396098.0
2019-01-30 18:00:00	SPY	ETF	267.96	268.34	267.78	268.31	184572.0
2019-01-30 19:00:00	SPY	ETF	268.31	268.31	267.75	267.86	136702.0
2019-01-30 20:00:00	SPY	ETF	267.58	267.98	267.58	267.98	1000.0
2019-01-30 04:00:00	QQQ	ETF	162.73	162.92	162.67	162.78	18195.0
2019-01-30 05:00:00	QQQ	ETF	162.8	162.85	162.66	162.82	19812.0
2019-01-30 06:00:00	QQQ	ETF	162.79	162.93	162.7	162.91	9107.0
2019-01-30 07:00:00	QQQ	ETF	162.95	163.23	162.92	163.09	101217.0
2019-01-30 08:00:00	QQQ	ETF	161.57	163.19	161.57	163.11	272752.0
2019-01-30 09:00:00	QQQ	ETF	163.07	163.91	163.07	163.29	3976438.0
2019-01-30 10:00:00	QQQ	ETF	163.27	163.54	162.89	163.26	2992610.0
2019-01-30 11:00:00	QQQ	ETF	163.28	163.81	163.26	163.81	2109833.0
2019-01-30 12:00:00	QQQ	ETF	163.81	164.51	163.78	164.28	3655343.0
2019-01-30 13:00:00	QQQ	ETF	164.295	164.39	164.03	164.12	1649286.0
2019-01-30 14:00:00	QQQ	ETF	164.115	166.28	163.97	166.24	10482232.0
2019-01-30 15:00:00	QQQ	ETF	166.2498	166.2498	165.4	165.81	9972733.0
2019-01-30 16:00:00	QQQ	ETF	165.81	166.54	165.18	166.39	1766553.0
2019-01-30 17:00:00	QQQ	ETF	166.45	166.63	165.3	166.63	216700.0
2019-01-30 18:00:00	QQQ	ETF	166.62	167.0	166.62	167.0	159109.0
2019-01-30 19:00:00	QQQ	ETF	167.0	167.09	166.6	166.71	223079.0
2019-01-30 04:00:00	IWM	ETF	146.6	146.6	146.6	146.6	200.0
2019-01-30 05:00:00	IWM	ETF	146.53	146.57	146.53	146.57	200.0
2019-01-30 06:00:00	IWM	ETF	146.59	146.59	146.59	146.59	300.0
2019-01-30 07:00:00	IWM	ETF	146.75	146.95	146.69	146.7	18551.0
2019-01-30 08:00:00	IWM	ETF	146.79	146.83	146.6	146.76	17624.0
2019-01-30 09:00:00	IWM	ETF	146.75	147.04	145.79	145.9	2609982.0
2019-01-30 10:00:00	IWM	ETF	145.89	146.93	145.68	146.72	2566667.0
2019-01-30 11:00:00	IWM	ETF	146.73	146.99	146.535	146.79	1689363.0
2019-01-30 12:00:00	IWM	ETF	146.79	147.26	146.77	146.995	1553896.0
2019-01-30 13:00:00	IWM	ETF	146.998	147.02	146.67	146.8104	1068927.0
2019-01-30 14:00:00	IWM	ETF	146.79	148.33	146.73	148.32	4399980.0
2019-01-30 15:00:00	IWM	ETF	148.32	148.34	147.36	147.79	4002090.0
2019-01-30 16:00:00	IWM	ETF	147.79	147.99	146.87	147.96	4096421.0
2019-01-30 17:00:00	IWM	ETF	147.86	147.93	147.81	147.87	7576.0
2019-01-30 18:00:00	IWM	ETF	147.86	148.1	147.8	148.09	20550.0
2019-01-30 19:00:00	IWM	ETF	148.1199	148.1199	147.8	147.86	16274.0
2019-01-30 04:00:00	DIA	ETF	246.56	246.64	246.56	246.64	300.0

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

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