PREVIEW / etf_1hour / 2022-03-08

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-03-08.parquet
  size:    480 KB
  rows:    17,517

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-03-08 04:00:00	SPY	ETF	420.0	421.62	420.0	421.0	112485.0
2022-03-08 05:00:00	SPY	ETF	421.08	421.51	419.14	421.22	126814.0
2022-03-08 06:00:00	SPY	ETF	421.0	421.64	420.33	421.64	143314.0
2022-03-08 07:00:00	SPY	ETF	421.59	423.03	419.72	420.2	889445.0
2022-03-08 08:00:00	SPY	ETF	421.5499	423.0	414.0	419.88	1278390.0
2022-03-08 09:00:00	SPY	ETF	419.8	421.19	417.76	418.6899	12274587.0
2022-03-08 10:00:00	SPY	ETF	418.678	419.56	415.39	419.32	17298679.0
2022-03-08 11:00:00	SPY	ETF	419.35	419.77	415.12	417.9401	11780274.0
2022-03-08 12:00:00	SPY	ETF	417.97	425.56	417.68	425.165	19136793.0
2022-03-08 13:00:00	SPY	ETF	425.18	427.21	419.36	419.53	16705931.0
2022-03-08 14:00:00	SPY	ETF	419.52	422.77	417.81	421.47	16347059.0
2022-03-08 15:00:00	SPY	ETF	421.47	423.53	416.25	416.3	24212064.0
2022-03-08 16:00:00	SPY	ETF	416.3	416.5532	414.58	414.94	7148349.0
2022-03-08 17:00:00	SPY	ETF	415.12	416.25	414.61	414.75	252386.0
2022-03-08 18:00:00	SPY	ETF	414.81	416.75	414.81	416.59	300790.0
2022-03-08 19:00:00	SPY	ETF	416.67	417.75	416.62	417.45	253441.0
2022-03-08 04:00:00	QQQ	ETF	324.76	326.18	324.61	325.36	169480.0
2022-03-08 05:00:00	QQQ	ETF	325.69	325.72	323.99	325.65	115234.0
2022-03-08 06:00:00	QQQ	ETF	325.3	325.75	324.41	325.56	186050.0
2022-03-08 07:00:00	QQQ	ETF	325.55	327.3	324.2	324.58	931002.0
2022-03-08 08:00:00	QQQ	ETF	324.56	327.2701	319.9	324.08	1009354.0
2022-03-08 09:00:00	QQQ	ETF	324.06	326.13	322.46	323.18	11713361.0
2022-03-08 10:00:00	QQQ	ETF	323.155	324.93	320.05	324.63	15234705.0
2022-03-08 11:00:00	QQQ	ETF	324.63	325.39	319.94	322.4701	9789100.0
2022-03-08 12:00:00	QQQ	ETF	322.5	332.07	322.21	331.4	14390102.0
2022-03-08 13:00:00	QQQ	ETF	331.46	333.21	325.61	325.665	11112547.0
2022-03-08 14:00:00	QQQ	ETF	325.66	328.62	324.11	327.2894	9435603.0
2022-03-08 15:00:00	QQQ	ETF	327.28	329.45	323.2	323.28	13380478.0
2022-03-08 16:00:00	QQQ	ETF	323.27	323.4863	321.53	321.92	1798036.0
2022-03-08 17:00:00	QQQ	ETF	321.76	323.35	321.63	321.89	183708.0
2022-03-08 18:00:00	QQQ	ETF	321.67	323.25	321.67	323.13	163504.0
2022-03-08 19:00:00	QQQ	ETF	323.13	323.83	323.13	323.8	219054.0
2022-03-08 04:00:00	IWM	ETF	194.8	195.49	194.59	194.99	17540.0
2022-03-08 05:00:00	IWM	ETF	194.63	195.5	194.1	195.3	26274.0
2022-03-08 06:00:00	IWM	ETF	195.03	195.4	194.9	195.35	69909.0
2022-03-08 07:00:00	IWM	ETF	195.38	196.07	194.47	194.59	229640.0
2022-03-08 08:00:00	IWM	ETF	195.39	195.91	193.88	194.46	207006.0
2022-03-08 09:00:00	IWM	ETF	194.38	195.1971	193.52	194.55	3988438.0
2022-03-08 10:00:00	IWM	ETF	194.53	195.89	193.46	195.85	4526013.0
2022-03-08 11:00:00	IWM	ETF	195.87	196.38	193.99	195.73	3969178.0
2022-03-08 12:00:00	IWM	ETF	195.74	198.83	195.51	198.37	5377771.0
2022-03-08 13:00:00	IWM	ETF	198.37	199.57	195.89	195.91	3629251.0
2022-03-08 14:00:00	IWM	ETF	195.91	197.9	194.98	197.28	4373038.0
2022-03-08 15:00:00	IWM	ETF	197.29	198.14	194.78	194.83	5243110.0
2022-03-08 16:00:00	IWM	ETF	194.79	197.5	193.69	193.99	2437016.0
2022-03-08 17:00:00	IWM	ETF	194.28	194.79	193.65	193.93	141636.0
2022-03-08 18:00:00	IWM	ETF	193.89	194.94	193.88	194.92	63107.0
2022-03-08 19:00:00	IWM	ETF	194.98	195.38	194.91	195.24	82220.0
2022-03-08 04:00:00	DIA	ETF	328.89	329.55	328.6	328.79	1804.0
2022-03-08 05:00:00	DIA	ETF	329.3	329.3	329.3	329.3	200.0

> showing 50 of 17,517 rows — these rows as CSV

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