PREVIEW / etf_1hour / 2022-10-11

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-10-11.parquet
  size:    458 KB
  rows:    16,941

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
2022-10-11 04:00:00	SPY	ETF	357.49	358.63	356.59	356.9	121098.0
2022-10-11 05:00:00	SPY	ETF	356.97	357.54	356.57	356.8	41827.0
2022-10-11 06:00:00	SPY	ETF	356.93	357.83	356.31	357.78	185922.0
2022-10-11 07:00:00	SPY	ETF	357.79	358.92	357.75	358.89	476828.0
2022-10-11 08:00:00	SPY	ETF	358.85	360.54	356.83	359.22	1426463.0
2022-10-11 09:00:00	SPY	ETF	359.19	359.56	356.5	356.59	7062036.0
2022-10-11 10:00:00	SPY	ETF	356.59	358.65	355.81	357.51	10511635.0
2022-10-11 11:00:00	SPY	ETF	357.53	361.49	357.45	360.759	9485628.0
2022-10-11 12:00:00	SPY	ETF	360.76	363.03	359.485	362.15	7555546.0
2022-10-11 13:00:00	SPY	ETF	362.16	362.38	360.87	361.89	5708476.0
2022-10-11 14:00:00	SPY	ETF	361.88	362.13	357.16	357.32	9724095.0
2022-10-11 15:00:00	SPY	ETF	357.3	358.24	355.71	357.74	20274688.0
2022-10-11 16:00:00	SPY	ETF	357.74	358.65	357.59	358.6	4147630.0
2022-10-11 17:00:00	SPY	ETF	358.51	358.69	358.31	358.45	101852.0
2022-10-11 18:00:00	SPY	ETF	358.41	358.48	357.86	358.2	188239.0
2022-10-11 19:00:00	SPY	ETF	358.19	358.4	357.8	358.24	106879.0
2022-10-11 04:00:00	QQQ	ETF	265.46	265.88	263.67	263.92	136574.0
2022-10-11 05:00:00	QQQ	ETF	264.0	264.35	263.51	263.8	77408.0
2022-10-11 06:00:00	QQQ	ETF	263.66	264.6	263.36	264.6	204173.0
2022-10-11 07:00:00	QQQ	ETF	264.56	265.19	264.44	265.15	322469.0
2022-10-11 08:00:00	QQQ	ETF	264.74	266.609	263.75	265.36	845784.0
2022-10-11 09:00:00	QQQ	ETF	265.2	265.39	262.32	262.36	6535580.0
2022-10-11 10:00:00	QQQ	ETF	262.37	264.27	261.53	262.94	8954964.0
2022-10-11 11:00:00	QQQ	ETF	262.935	266.56	262.865	265.71	7436207.0
2022-10-11 12:00:00	QQQ	ETF	265.74	267.63	264.54	266.575	6210966.0
2022-10-11 13:00:00	QQQ	ETF	266.58	266.88	265.22	266.02	3861988.0
2022-10-11 14:00:00	QQQ	ETF	266.03	266.29	262.07	262.275	5831179.0
2022-10-11 15:00:00	QQQ	ETF	262.26	263.22	261.03	262.89	10601662.0
2022-10-11 16:00:00	QQQ	ETF	262.85	263.79	262.3223	263.75	1473525.0
2022-10-11 17:00:00	QQQ	ETF	263.52	263.7	262.75	263.49	759413.0
2022-10-11 18:00:00	QQQ	ETF	263.45	263.68	263.07	263.25	115859.0
2022-10-11 19:00:00	QQQ	ETF	263.3	263.5	262.89	263.34	123336.0
2022-10-11 04:00:00	IWM	ETF	166.66	166.92	165.9	166.0	25032.0
2022-10-11 05:00:00	IWM	ETF	166.12	166.4	165.9	166.05	9458.0
2022-10-11 06:00:00	IWM	ETF	165.99	166.57	165.72	166.44	20643.0
2022-10-11 07:00:00	IWM	ETF	166.59	167.1	166.59	167.1	77784.0
2022-10-11 08:00:00	IWM	ETF	166.7183	168.08	166.68	167.39	172181.0
2022-10-11 09:00:00	IWM	ETF	167.4	167.61	165.36	165.37	1799741.0
2022-10-11 10:00:00	IWM	ETF	165.36	167.225	164.8	166.74	2686816.0
2022-10-11 11:00:00	IWM	ETF	166.735	169.14	166.68	168.77	2458162.0
2022-10-11 12:00:00	IWM	ETF	168.795	170.11	167.98	169.61	2317097.0
2022-10-11 13:00:00	IWM	ETF	169.665	169.74	168.94	169.1394	1442488.0
2022-10-11 14:00:00	IWM	ETF	169.1269	169.3	166.67	166.75	2937944.0
2022-10-11 15:00:00	IWM	ETF	166.71	168.145	166.015	167.72	5308993.0
2022-10-11 16:00:00	IWM	ETF	167.72	168.21	167.67	168.16	1002118.0
2022-10-11 17:00:00	IWM	ETF	168.19	168.24	167.72	167.96	752500.0
2022-10-11 18:00:00	IWM	ETF	168.0	168.15	167.82	168.0	61759.0
2022-10-11 19:00:00	IWM	ETF	167.99	168.19	167.79	168.08	13163.0
2022-10-11 04:00:00	DIA	ETF	290.48	290.48	289.57	289.57	1553.0
2022-10-11 05:00:00	DIA	ETF	290.0	290.1	289.68	289.68	1290.0

> showing 50 of 16,941 rows — these rows as CSV

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