PREVIEW / etf_1hour / 2020-01-16

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-01-16.parquet
  size:    357 KB
  rows:    11,755

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
2020-01-16 04:00:00	SPY	ETF	329.63	329.72	329.33	329.41	18026.0
2020-01-16 05:00:00	SPY	ETF	329.43	329.58	329.39	329.57	9871.0
2020-01-16 06:00:00	SPY	ETF	329.63	329.7	329.34	329.69	24540.0
2020-01-16 07:00:00	SPY	ETF	329.69	329.72	329.43	329.45	207540.0
2020-01-16 08:00:00	SPY	ETF	329.61	329.72	329.11	329.58	264000.0
2020-01-16 09:00:00	SPY	ETF	329.59	329.99	329.46	329.68	5480368.0
2020-01-16 10:00:00	SPY	ETF	329.67	330.03	329.51	329.69	6246855.0
2020-01-16 11:00:00	SPY	ETF	329.695	329.92	329.45	329.835	5512819.0
2020-01-16 12:00:00	SPY	ETF	329.84	330.0	329.74	329.89	2505030.0
2020-01-16 13:00:00	SPY	ETF	329.9	330.14	329.81	330.08	3349931.0
2020-01-16 14:00:00	SPY	ETF	330.08	330.14	329.89	329.97	3926535.0
2020-01-16 15:00:00	SPY	ETF	329.97	330.91	329.92	330.9	14794627.0
2020-01-16 16:00:00	SPY	ETF	330.9	330.93	330.622	330.85	6152961.0
2020-01-16 17:00:00	SPY	ETF	330.84	330.92	330.74	330.85	1087308.0
2020-01-16 18:00:00	SPY	ETF	330.85	331.43	330.81	331.12	212469.0
2020-01-16 19:00:00	SPY	ETF	331.11	331.14	331.0	331.13	45968.0
2020-01-16 04:00:00	QQQ	ETF	221.36	221.4	221.04	221.14	22875.0
2020-01-16 05:00:00	QQQ	ETF	221.11	221.33	221.04	221.33	9685.0
2020-01-16 06:00:00	QQQ	ETF	221.28	221.34	221.07	221.31	19906.0
2020-01-16 07:00:00	QQQ	ETF	221.31	221.4	221.12	221.15	120667.0
2020-01-16 08:00:00	QQQ	ETF	221.32	221.5	220.17	221.2	234702.0
2020-01-16 09:00:00	QQQ	ETF	221.2	221.79	221.07	221.6	2334038.0
2020-01-16 10:00:00	QQQ	ETF	221.58	221.83	221.11	221.16	2368333.0
2020-01-16 11:00:00	QQQ	ETF	221.18	221.41	220.8	221.2201	1693945.0
2020-01-16 12:00:00	QQQ	ETF	221.22	221.33	221.13	221.19	952973.0
2020-01-16 13:00:00	QQQ	ETF	221.2	221.5265	221.09	221.5001	1229168.0
2020-01-16 14:00:00	QQQ	ETF	221.505	221.66	221.44	221.509	1177572.0
2020-01-16 15:00:00	QQQ	ETF	221.5016	222.32	221.44	222.3	3598132.0
2020-01-16 16:00:00	QQQ	ETF	222.3	222.34	222.12	222.28	1496685.0
2020-01-16 17:00:00	QQQ	ETF	222.3	222.31	222.23	222.23	138532.0
2020-01-16 18:00:00	QQQ	ETF	222.29	222.73	222.2	222.48	45932.0
2020-01-16 19:00:00	QQQ	ETF	222.47	222.52	222.43	222.47	29617.0
2020-01-16 04:00:00	IWM	ETF	168.34	169.06	168.31	168.31	7977.0
2020-01-16 05:00:00	IWM	ETF	168.14	168.17	168.13	168.17	900.0
2020-01-16 06:00:00	IWM	ETF	168.42	168.42	168.33	168.4	1900.0
2020-01-16 07:00:00	IWM	ETF	168.42	168.42	168.31	168.38	37709.0
2020-01-16 08:00:00	IWM	ETF	168.37	168.73	167.91	168.59	106618.0
2020-01-16 09:00:00	IWM	ETF	168.57	169.52	168.43	169.42	3004060.0
2020-01-16 10:00:00	IWM	ETF	169.42	169.865	169.15	169.37	4024559.0
2020-01-16 11:00:00	IWM	ETF	169.38	169.51	168.91	169.09	1815448.0
2020-01-16 12:00:00	IWM	ETF	169.09	169.49	169.09	169.32	916644.0
2020-01-16 13:00:00	IWM	ETF	169.32	169.46	169.19	169.36	902132.0
2020-01-16 14:00:00	IWM	ETF	169.36	169.46	169.11	169.185	1203698.0
2020-01-16 15:00:00	IWM	ETF	169.18	169.6	169.14	169.57	3192525.0
2020-01-16 16:00:00	IWM	ETF	169.53	169.64	169.4	169.54	765786.0
2020-01-16 17:00:00	IWM	ETF	169.45	169.53	169.45	169.53	2851.0
2020-01-16 18:00:00	IWM	ETF	169.52	169.88	169.44	169.73	26065.0
2020-01-16 19:00:00	IWM	ETF	169.7	169.73	169.65	169.69	8900.0
2020-01-16 04:00:00	DIA	ETF	291.52	291.52	291.52	291.52	116.0
2020-01-16 05:00:00	DIA	ETF	291.51	291.51	291.51	291.51	100.0

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

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