PREVIEW / etf_1hour / 2008-03-24

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-03-24.parquet
  size:    103 KB
  rows:    3,425

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
2008-03-24 04:00:00	SPY	ETF	132.79	132.79	132.62	132.7	4600.0
2008-03-24 05:00:00	SPY	ETF	132.96	132.96	132.96	132.96	600.0
2008-03-24 06:00:00	SPY	ETF	132.93	133.0	132.74	132.74	48100.0
2008-03-24 07:00:00	SPY	ETF	132.71	133.19	132.67	133.05	447400.0
2008-03-24 08:00:00	SPY	ETF	133.05	133.51	132.93	133.43	2897100.0
2008-03-24 09:00:00	SPY	ETF	133.42	134.45	132.55	134.26	33768463.0
2008-03-24 10:00:00	SPY	ETF	134.26	135.38	134.1399	134.98	42528204.0
2008-03-24 11:00:00	SPY	ETF	134.98	135.59	134.79	135.21	24051122.0
2008-03-24 12:00:00	SPY	ETF	135.22	135.81	134.9	135.51	18235298.0
2008-03-24 13:00:00	SPY	ETF	135.51	135.66	135.37	135.65	14697362.0
2008-03-24 14:00:00	SPY	ETF	135.65	135.66	134.92	134.98	20213748.0
2008-03-24 15:00:00	SPY	ETF	134.97	135.31	134.44	134.77	43338457.0
2008-03-24 16:00:00	SPY	ETF	134.81	135.4	134.6	134.75	5993400.0
2008-03-24 17:00:00	SPY	ETF	134.75	134.85	132.75	134.83	469400.0
2008-03-24 18:00:00	SPY	ETF	134.83	135.33	134.83	135.17	221000.0
2008-03-24 19:00:00	SPY	ETF	135.2	135.2	135.03	135.14	31500.0
2008-03-24 06:00:00	QQQ	ETF	43.05	43.11	43.05	43.08	7100.0
2008-03-24 07:00:00	QQQ	ETF	43.03	43.16	43.03	43.11	113451.0
2008-03-24 08:00:00	QQQ	ETF	43.12	43.32	43.09	43.28	1878284.0
2008-03-24 09:00:00	QQQ	ETF	43.27	43.7	43.18	43.66	22122771.0
2008-03-24 10:00:00	QQQ	ETF	43.66	44.4	43.6301	44.2	28504374.0
2008-03-24 11:00:00	QQQ	ETF	44.2	44.54	44.18	44.45	10796971.0
2008-03-24 12:00:00	QQQ	ETF	44.45	44.74	44.38	44.62	12456434.0
2008-03-24 13:00:00	QQQ	ETF	44.62	44.76	44.56	44.76	8667385.0
2008-03-24 14:00:00	QQQ	ETF	44.76	44.76	44.45	44.47	10936467.0
2008-03-24 15:00:00	QQQ	ETF	44.47	44.67	44.42	44.59	22292768.0
2008-03-24 16:00:00	QQQ	ETF	44.59	44.68	44.2438	44.58	5087260.0
2008-03-24 17:00:00	QQQ	ETF	44.6	44.66	44.59	44.66	401909.0
2008-03-24 18:00:00	QQQ	ETF	44.65	44.72	44.64	44.71	75251.0
2008-03-24 19:00:00	QQQ	ETF	44.7	44.71	44.67	44.67	46855.0
2008-03-24 07:00:00	IWM	ETF	67.89	68.06	67.89	68.0	38300.0
2008-03-24 08:00:00	IWM	ETF	68.09	68.26	67.95	68.18	298800.0
2008-03-24 09:00:00	IWM	ETF	68.18	68.8	67.95	68.7	15260969.0
2008-03-24 10:00:00	IWM	ETF	68.71	70.0	68.67	69.7	19945838.0
2008-03-24 11:00:00	IWM	ETF	69.7	70.12	69.68	69.99	7825154.0
2008-03-24 12:00:00	IWM	ETF	69.99	70.35	69.83	70.18	8523850.0
2008-03-24 13:00:00	IWM	ETF	70.18	70.32	70.05	70.32	4837855.0
2008-03-24 14:00:00	IWM	ETF	70.31	70.32	69.87	69.91	5986248.0
2008-03-24 15:00:00	IWM	ETF	69.9	70.03	69.54	69.99	12580552.0
2008-03-24 16:00:00	IWM	ETF	70.0	70.03	69.52	69.98	3969793.0
2008-03-24 17:00:00	IWM	ETF	69.95	70.0	69.92	70.0	4013300.0
2008-03-24 18:00:00	IWM	ETF	70.03	70.13	70.03	70.13	29100.0
2008-03-24 19:00:00	IWM	ETF	70.11	70.11	70.11	70.11	200.0
2008-03-24 07:00:00	DIA	ETF	123.63	123.79	123.63	123.75	2000.0
2008-03-24 08:00:00	DIA	ETF	123.74	124.15	123.71	124.08	26500.0
2008-03-24 09:00:00	DIA	ETF	124.05	124.81	123.96	124.8	2420093.0
2008-03-24 10:00:00	DIA	ETF	124.79	125.85	124.76	125.61	3890681.0
2008-03-24 11:00:00	DIA	ETF	125.62	126.02	125.47	125.76	1433187.0
2008-03-24 12:00:00	DIA	ETF	125.76	126.1	125.61	125.88	1329821.0
2008-03-24 13:00:00	DIA	ETF	125.88	126.07	125.8	126.07	888284.0

> showing 50 of 3,425 rows — these rows as CSV

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