PREVIEW / etf_1hour / 2020-04-01

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-04-01.parquet
  size:    380 KB
  rows:    12,993

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-04-01 04:00:00	SPY	ETF	251.84	251.98	248.35	249.7	317707.0
2020-04-01 05:00:00	SPY	ETF	249.7	250.76	249.15	250.3	154632.0
2020-04-01 06:00:00	SPY	ETF	250.25	251.01	248.95	249.4	326254.0
2020-04-01 07:00:00	SPY	ETF	249.46	249.69	248.37	248.75	895783.0
2020-04-01 08:00:00	SPY	ETF	248.74	257.75	247.29	248.5	2419710.0
2020-04-01 09:00:00	SPY	ETF	248.58	249.88	247.41	248.89	20179846.0
2020-04-01 10:00:00	SPY	ETF	248.92	250.72	248.18	250.23	26562330.0
2020-04-01 11:00:00	SPY	ETF	250.22	251.44	248.27	248.75	21773424.0
2020-04-01 12:00:00	SPY	ETF	248.72	248.76	245.81	246.242	23526631.0
2020-04-01 13:00:00	SPY	ETF	246.225	248.15	245.94	247.9	17335890.0
2020-04-01 14:00:00	SPY	ETF	247.9	257.6591	245.73	245.79	24202281.0
2020-04-01 15:00:00	SPY	ETF	245.775	247.24	243.9	246.12	38141326.0
2020-04-01 16:00:00	SPY	ETF	246.09	248.6285	245.1	246.12	11157682.0
2020-04-01 17:00:00	SPY	ETF	246.12	246.14	245.75	246.14	296000.0
2020-04-01 18:00:00	SPY	ETF	246.14	247.9	246.14	246.5	789919.0
2020-04-01 19:00:00	SPY	ETF	246.49	247.59	246.07	247.5	390663.0
2020-04-01 04:00:00	QQQ	ETF	185.61	186.04	184.31	185.16	80396.0
2020-04-01 05:00:00	QQQ	ETF	185.51	186.0	184.83	185.59	49869.0
2020-04-01 06:00:00	QQQ	ETF	185.78	186.14	184.69	185.08	175470.0
2020-04-01 07:00:00	QQQ	ETF	185.1	185.5	184.58	184.92	471822.0
2020-04-01 08:00:00	QQQ	ETF	184.91	188.12	183.85	184.78	651745.0
2020-04-01 09:00:00	QQQ	ETF	184.84	186.385	184.55	185.21	6341308.0
2020-04-01 10:00:00	QQQ	ETF	185.22	187.04	184.78	186.7011	7042350.0
2020-04-01 11:00:00	QQQ	ETF	186.68	187.66	185.22	185.58	5278140.0
2020-04-01 12:00:00	QQQ	ETF	185.56	185.56	183.18	183.46	5963089.0
2020-04-01 13:00:00	QQQ	ETF	183.44	184.33	183.28	184.1465	5062753.0
2020-04-01 14:00:00	QQQ	ETF	184.13	184.6	182.28	182.36	4393676.0
2020-04-01 15:00:00	QQQ	ETF	182.37	183.09	180.86	182.39	10048147.0
2020-04-01 16:00:00	QQQ	ETF	182.38	184.3431	181.61	182.33	982444.0
2020-04-01 17:00:00	QQQ	ETF	182.21	182.38	182.09	182.3	30814.0
2020-04-01 18:00:00	QQQ	ETF	182.28	183.52	182.28	182.59	133580.0
2020-04-01 19:00:00	QQQ	ETF	182.5401	183.39	182.38	183.38	62742.0
2020-04-01 04:00:00	IWM	ETF	108.64	108.75	108.24	108.68	9079.0
2020-04-01 05:00:00	IWM	ETF	108.79	109.13	108.74	109.07	9798.0
2020-04-01 06:00:00	IWM	ETF	109.13	109.23	108.5	108.5	44209.0
2020-04-01 07:00:00	IWM	ETF	108.5	108.99	108.5	108.77	67948.0
2020-04-01 08:00:00	IWM	ETF	108.6001	111.05	108.1	108.87	264191.0
2020-04-01 09:00:00	IWM	ETF	108.81	109.74	108.14	108.67	5042670.0
2020-04-01 10:00:00	IWM	ETF	108.675	110.36	108.45	109.825	5446560.0
2020-04-01 11:00:00	IWM	ETF	109.82	110.38	108.67	108.79	3735516.0
2020-04-01 12:00:00	IWM	ETF	108.78	108.79	106.34	106.76	5216450.0
2020-04-01 13:00:00	IWM	ETF	106.73	107.82	106.48	107.65	3537493.0
2020-04-01 14:00:00	IWM	ETF	107.64	107.85	106.38	106.7	4482401.0
2020-04-01 15:00:00	IWM	ETF	106.7	107.2	105.525	106.65	11086653.0
2020-04-01 16:00:00	IWM	ETF	106.67	107.6195	106.1	106.73	1968225.0
2020-04-01 17:00:00	IWM	ETF	106.35	106.64	106.35	106.49	905.0
2020-04-01 18:00:00	IWM	ETF	106.58	107.2	106.58	106.6	51405.0
2020-04-01 19:00:00	IWM	ETF	106.63	107.14	106.56	107.14	10312.0
2020-04-01 04:00:00	DIA	ETF	212.0	212.73	211.04	212.73	16432.0
2020-04-01 05:00:00	DIA	ETF	212.79	213.23	212.0	213.23	7936.0

> showing 50 of 12,993 rows — these rows as CSV

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