PREVIEW / etf_1hour / 2019-01-22

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-01-22.parquet
  size:    337 KB
  rows:    11,182

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-22 04:00:00	SPY	ETF	265.11	265.25	264.9	264.98	40303.0
2019-01-22 05:00:00	SPY	ETF	265.0	265.02	264.65	264.65	35732.0
2019-01-22 06:00:00	SPY	ETF	264.65	264.67	264.3	264.62	87378.0
2019-01-22 07:00:00	SPY	ETF	264.67	265.11	264.63	264.9	295622.0
2019-01-22 08:00:00	SPY	ETF	265.0503	266.151	264.4	264.8	329957.0
2019-01-22 09:00:00	SPY	ETF	264.78	266.46	264.02	264.3962	9197210.0
2019-01-22 10:00:00	SPY	ETF	264.4	264.4	263.54	263.79	10956092.0
2019-01-22 11:00:00	SPY	ETF	263.77	264.18	262.83	262.88	9019198.0
2019-01-22 12:00:00	SPY	ETF	262.88	263.28	262.6601	262.95	7085480.0
2019-01-22 13:00:00	SPY	ETF	262.94	262.94	261.725	262.51	13600386.0
2019-01-22 14:00:00	SPY	ETF	262.5	262.56	261.21	261.7	10100584.0
2019-01-22 15:00:00	SPY	ETF	261.69	262.93	261.06	262.93	33726946.0
2019-01-22 16:00:00	SPY	ETF	262.925	263.2	262.47	262.67	18684095.0
2019-01-22 17:00:00	SPY	ETF	262.74	263.0	262.68	262.73	366177.0
2019-01-22 18:00:00	SPY	ETF	262.71	262.73	262.24	262.47	140038.0
2019-01-22 19:00:00	SPY	ETF	262.51	262.85	262.41	262.67	67320.0
2019-01-22 04:00:00	QQQ	ETF	164.06	164.08	163.83	163.92	40645.0
2019-01-22 05:00:00	QQQ	ETF	163.91	163.95	163.71	163.72	47048.0
2019-01-22 06:00:00	QQQ	ETF	163.67	163.74	163.46	163.74	39731.0
2019-01-22 07:00:00	QQQ	ETF	163.76	164.02	163.73	163.92	117631.0
2019-01-22 08:00:00	QQQ	ETF	165.25	165.25	163.5	163.95	317785.0
2019-01-22 09:00:00	QQQ	ETF	163.98	165.25	163.3	163.69	5226521.0
2019-01-22 10:00:00	QQQ	ETF	163.69	163.69	163.1	163.27	5000143.0
2019-01-22 11:00:00	QQQ	ETF	163.26	163.48	162.4801	162.52	4175162.0
2019-01-22 12:00:00	QQQ	ETF	162.51	162.83	162.33	162.48	3426094.0
2019-01-22 13:00:00	QQQ	ETF	162.48	162.48	161.585	162.04	5369109.0
2019-01-22 14:00:00	QQQ	ETF	162.03	162.1	160.95	161.21	5317569.0
2019-01-22 15:00:00	QQQ	ETF	161.21	162.07	160.76	162.07	11672361.0
2019-01-22 16:00:00	QQQ	ETF	162.06	162.27	161.66	161.8	2903674.0
2019-01-22 17:00:00	QQQ	ETF	161.75	161.93	161.75	161.8482	35944.0
2019-01-22 18:00:00	QQQ	ETF	161.76	161.82	161.49	161.82	55913.0
2019-01-22 19:00:00	QQQ	ETF	161.8	162.05	161.78	161.89	38834.0
2019-01-22 04:00:00	IWM	ETF	146.41	146.43	146.37	146.43	919.0
2019-01-22 05:00:00	IWM	ETF	146.38	146.38	146.32	146.34	6221.0
2019-01-22 06:00:00	IWM	ETF	146.3	146.3	146.19	146.19	3800.0
2019-01-22 07:00:00	IWM	ETF	146.29	146.6	146.29	146.5	45728.0
2019-01-22 08:00:00	IWM	ETF	146.36	146.63	146.32	146.36	84850.0
2019-01-22 09:00:00	IWM	ETF	146.39	146.76	145.14	145.67	3277755.0
2019-01-22 10:00:00	IWM	ETF	145.65	145.93	145.17	145.59	2681750.0
2019-01-22 11:00:00	IWM	ETF	145.58	146.11	145.13	145.16	3524499.0
2019-01-22 12:00:00	IWM	ETF	145.15	145.47	144.9999	145.27	2092634.0
2019-01-22 13:00:00	IWM	ETF	145.24	145.25	144.26	145.04	2623403.0
2019-01-22 14:00:00	IWM	ETF	145.03	145.13	144.05	144.43	2367411.0
2019-01-22 15:00:00	IWM	ETF	144.43	145.08	144.12	144.94	5154589.0
2019-01-22 16:00:00	IWM	ETF	144.94	145.28	144.5814	145.02	2013457.0
2019-01-22 17:00:00	IWM	ETF	145.0	145.14	145.0	145.02	303892.0
2019-01-22 18:00:00	IWM	ETF	144.95	144.95	144.8	144.9	10195.0
2019-01-22 19:00:00	IWM	ETF	144.96	145.07	144.86	144.97	2550.0
2019-01-22 04:00:00	DIA	ETF	246.38	246.38	245.66	245.69	3208.0
2019-01-22 05:00:00	DIA	ETF	245.48	245.48	245.48	245.48	300.0

> showing 50 of 11,182 rows — these rows as CSV

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