PREVIEW / etf_1hour / 2021-10-11

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-10-11.parquet
  size:    413 KB
  rows:    14,366

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
2021-10-11 04:00:00	SPY	ETF	436.5	436.76	435.94	436.41	29480.0
2021-10-11 05:00:00	SPY	ETF	436.42	436.86	436.33	436.66	8799.0
2021-10-11 06:00:00	SPY	ETF	436.61	436.65	435.36	435.63	63870.0
2021-10-11 07:00:00	SPY	ETF	435.67	436.41	435.5	435.88	178358.0
2021-10-11 08:00:00	SPY	ETF	435.6201	438.158	435.54	436.8	391040.0
2021-10-11 09:00:00	SPY	ETF	436.84	439.41	436.76	439.39	5594650.0
2021-10-11 10:00:00	SPY	ETF	439.4	440.26	439.36	439.64	5332665.0
2021-10-11 11:00:00	SPY	ETF	439.65	440.14	439.13	439.6	4073413.0
2021-10-11 12:00:00	SPY	ETF	439.59	439.68	437.72	438.06	5267996.0
2021-10-11 13:00:00	SPY	ETF	438.07	438.08	435.93	436.48	7721976.0
2021-10-11 14:00:00	SPY	ETF	436.475	437.32	436.2	436.83	5211065.0
2021-10-11 15:00:00	SPY	ETF	436.81	437.07	434.62	434.66	12599495.0
2021-10-11 16:00:00	SPY	ETF	434.66	434.7417	434.0	434.37	3221885.0
2021-10-11 17:00:00	SPY	ETF	434.24	434.5	434.24	434.44	62870.0
2021-10-11 18:00:00	SPY	ETF	434.43	434.69	433.82	433.9	152320.0
2021-10-11 19:00:00	SPY	ETF	433.9	434.45	433.82	434.4	97275.0
2021-10-11 04:00:00	QQQ	ETF	360.46	360.46	359.01	359.57	83878.0
2021-10-11 05:00:00	QQQ	ETF	359.76	360.01	359.45	359.74	77345.0
2021-10-11 06:00:00	QQQ	ETF	359.66	359.66	358.16	358.46	173264.0
2021-10-11 07:00:00	QQQ	ETF	358.46	359.11	358.11	358.3	212209.0
2021-10-11 08:00:00	QQQ	ETF	358.58	361.43	358.0	359.17	432535.0
2021-10-11 09:00:00	QQQ	ETF	359.2	362.31	358.94	362.28	4430485.0
2021-10-11 10:00:00	QQQ	ETF	362.2799	363.2	362.01	362.38	3583157.0
2021-10-11 11:00:00	QQQ	ETF	362.375	362.87	362.13	362.35	2426631.0
2021-10-11 12:00:00	QQQ	ETF	362.35	362.42	361.11	361.68	3500131.0
2021-10-11 13:00:00	QQQ	ETF	361.695	361.695	359.82	360.4017	4298155.0
2021-10-11 14:00:00	QQQ	ETF	360.42	361.2175	360.12	360.735	3069917.0
2021-10-11 15:00:00	QQQ	ETF	360.73	360.92	358.3	358.39	6540205.0
2021-10-11 16:00:00	QQQ	ETF	358.39	358.43	357.85	358.04	797515.0
2021-10-11 17:00:00	QQQ	ETF	358.07	358.14	358.02	358.08	26729.0
2021-10-11 18:00:00	QQQ	ETF	358.11	358.26	357.55	357.61	118638.0
2021-10-11 19:00:00	QQQ	ETF	357.67	358.13	357.61	358.01	65844.0
2021-10-11 04:00:00	IWM	ETF	220.69	221.01	220.29	220.81	26015.0
2021-10-11 05:00:00	IWM	ETF	220.87	221.12	220.68	220.89	20022.0
2021-10-11 06:00:00	IWM	ETF	221.05	221.05	220.28	220.46	25672.0
2021-10-11 07:00:00	IWM	ETF	220.56	221.12	220.45	220.87	87448.0
2021-10-11 08:00:00	IWM	ETF	220.57	221.77	220.48	221.66	94230.0
2021-10-11 09:00:00	IWM	ETF	221.71	222.78	221.25	222.59	2211119.0
2021-10-11 10:00:00	IWM	ETF	222.6	223.5	222.43	223.1618	1638589.0
2021-10-11 11:00:00	IWM	ETF	223.16	223.55	222.94	223.46	1000327.0
2021-10-11 12:00:00	IWM	ETF	223.4489	223.52	222.13	222.25	1499194.0
2021-10-11 13:00:00	IWM	ETF	222.27	222.27	221.37	221.941	1342407.0
2021-10-11 14:00:00	IWM	ETF	221.95	222.27	221.56	222.04	1322829.0
2021-10-11 15:00:00	IWM	ETF	222.03	222.26	220.25	220.31	3019260.0
2021-10-11 16:00:00	IWM	ETF	220.31	220.32	220.05	220.19	584803.0
2021-10-11 17:00:00	IWM	ETF	220.11	220.42	220.11	220.3	274706.0
2021-10-11 18:00:00	IWM	ETF	220.26	220.37	219.82	219.89	36624.0
2021-10-11 19:00:00	IWM	ETF	219.84	220.15	219.83	220.15	49103.0
2021-10-11 04:00:00	DIA	ETF	346.8	346.91	346.7	346.7	10176.0
2021-10-11 05:00:00	DIA	ETF	346.91	346.91	346.91	346.91	100.0

> showing 50 of 14,366 rows — these rows as CSV

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