PREVIEW / etf_1hour / 2019-10-30

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-10-30.parquet
  size:    334 KB
  rows:    10,938

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-10-30 04:00:00	SPY	ETF	303.17	303.21	302.93	302.93	7006.0
2019-10-30 05:00:00	SPY	ETF	302.96	303.07	302.93	303.03	7022.0
2019-10-30 06:00:00	SPY	ETF	303.08	303.28	303.01	303.17	8990.0
2019-10-30 07:00:00	SPY	ETF	303.19	303.42	303.19	303.32	24262.0
2019-10-30 08:00:00	SPY	ETF	303.2499	303.49	302.95	303.42	93907.0
2019-10-30 09:00:00	SPY	ETF	303.41	303.52	302.65	302.87	3372519.0
2019-10-30 10:00:00	SPY	ETF	302.865	303.1	301.99	303.06	6285281.0
2019-10-30 11:00:00	SPY	ETF	303.06	303.09	302.53	302.79	3459817.0
2019-10-30 12:00:00	SPY	ETF	302.78	303.17	302.75	302.9	2641028.0
2019-10-30 13:00:00	SPY	ETF	302.91	303.05	302.41	302.5	4142897.0
2019-10-30 14:00:00	SPY	ETF	302.49	303.81	302.1	303.6696	11140729.0
2019-10-30 15:00:00	SPY	ETF	303.66	304.55	303.64	304.14	11254701.0
2019-10-30 16:00:00	SPY	ETF	304.14	305.13	304.08	304.75	6132787.0
2019-10-30 17:00:00	SPY	ETF	304.63	304.86	304.6	304.75	207675.0
2019-10-30 18:00:00	SPY	ETF	304.7	304.73	304.5	304.54	54673.0
2019-10-30 19:00:00	SPY	ETF	304.54	304.6	304.45	304.5	35768.0
2019-10-30 04:00:00	QQQ	ETF	196.09	196.12	196.09	196.12	800.0
2019-10-30 05:00:00	QQQ	ETF	196.03	196.1	195.99	196.09	8120.0
2019-10-30 06:00:00	QQQ	ETF	196.11	196.19	196.06	196.17	6800.0
2019-10-30 07:00:00	QQQ	ETF	196.16	196.47	196.16	196.42	44315.0
2019-10-30 08:00:00	QQQ	ETF	196.43	196.59	196.02	196.51	77570.0
2019-10-30 09:00:00	QQQ	ETF	196.5	196.59	195.72	196.0301	2486645.0
2019-10-30 10:00:00	QQQ	ETF	196.04	196.42	195.29	196.39	3791937.0
2019-10-30 11:00:00	QQQ	ETF	196.39	196.4	195.775	196.0	1491343.0
2019-10-30 12:00:00	QQQ	ETF	195.99	196.21	195.89	195.94	1192269.0
2019-10-30 13:00:00	QQQ	ETF	195.97	196.19	195.68	195.74	1435603.0
2019-10-30 14:00:00	QQQ	ETF	195.72	196.76	195.39	196.7	3793298.0
2019-10-30 15:00:00	QQQ	ETF	196.7	197.32	196.66	196.94	4217815.0
2019-10-30 16:00:00	QQQ	ETF	196.93	198.17	196.69	197.64	1466941.0
2019-10-30 17:00:00	QQQ	ETF	197.64	198.0	197.52	197.89	68784.0
2019-10-30 18:00:00	QQQ	ETF	197.94	197.95	197.67	197.71	27390.0
2019-10-30 19:00:00	QQQ	ETF	197.71	197.78	197.65	197.77	27561.0
2019-10-30 06:00:00	IWM	ETF	156.78	156.79	156.78	156.79	2600.0
2019-10-30 07:00:00	IWM	ETF	156.88	156.99	156.86	156.99	1800.0
2019-10-30 08:00:00	IWM	ETF	156.9799	156.9799	156.82	156.87	13737.0
2019-10-30 09:00:00	IWM	ETF	156.88	156.891	155.92	155.94	1829800.0
2019-10-30 10:00:00	IWM	ETF	155.9387	156.25	155.28	155.89	2528736.0
2019-10-30 11:00:00	IWM	ETF	155.89	155.94	155.35	155.46	1019169.0
2019-10-30 12:00:00	IWM	ETF	155.46	155.94	155.46	155.88	879210.0
2019-10-30 13:00:00	IWM	ETF	155.89	155.99	155.53	155.67	899605.0
2019-10-30 14:00:00	IWM	ETF	155.59	156.47	155.47	156.4	1855376.0
2019-10-30 15:00:00	IWM	ETF	156.39	156.69	156.305	156.34	2760772.0
2019-10-30 16:00:00	IWM	ETF	156.34	156.68	156.33	156.54	783719.0
2019-10-30 17:00:00	IWM	ETF	156.67	156.69	156.67	156.69	2000.0
2019-10-30 18:00:00	IWM	ETF	156.49	156.49	156.46	156.48	725.0
2019-10-30 19:00:00	IWM	ETF	156.44	156.52	156.44	156.46	2100.0
2019-10-30 04:00:00	DIA	ETF	270.75	270.75	270.75	270.75	500.0
2019-10-30 07:00:00	DIA	ETF	270.91	270.91	270.87	270.87	800.0
2019-10-30 08:00:00	DIA	ETF	270.79	271.0	270.79	271.0	1442.0
2019-10-30 09:00:00	DIA	ETF	271.0	271.0	270.11	270.51	244502.0

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

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