PREVIEW / etf_1hour / 2009-03-24

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-03-24.parquet
  size:    132 KB
  rows:    4,090

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
2009-03-24 04:00:00	SPY	ETF	81.58	81.61	81.58	81.61	1000.0
2009-03-24 05:00:00	SPY	ETF	81.46	81.48	81.2	81.21	62324.0
2009-03-24 06:00:00	SPY	ETF	81.24	81.42	81.11	81.39	213650.0
2009-03-24 07:00:00	SPY	ETF	81.48	81.56	81.37	81.38	631874.0
2009-03-24 08:00:00	SPY	ETF	81.4	81.85	81.11	81.33	2321322.0
2009-03-24 09:00:00	SPY	ETF	81.32	81.47	80.9	81.44	37332061.0
2009-03-24 10:00:00	SPY	ETF	81.45	81.85	80.87	81.14	58546958.0
2009-03-24 11:00:00	SPY	ETF	81.14	82.2547	81.02	81.37	39354051.0
2009-03-24 12:00:00	SPY	ETF	81.37	82.08	81.16	81.98	32602993.0
2009-03-24 13:00:00	SPY	ETF	81.98	82.36	81.66	81.83	43569155.0
2009-03-24 14:00:00	SPY	ETF	81.8275	82.26	81.45	81.63	41798544.0
2009-03-24 15:00:00	SPY	ETF	81.62	82.2547	80.51	80.61	60907223.0
2009-03-24 16:00:00	SPY	ETF	80.59	81.18	80.54	80.61	5898481.0
2009-03-24 17:00:00	SPY	ETF	80.58	82.2547	80.51	80.57	3962062.0
2009-03-24 18:00:00	SPY	ETF	80.57	80.85	80.5	80.75	581453.0
2009-03-24 19:00:00	SPY	ETF	80.74	80.9	80.73	80.9	49919.0
2009-03-24 04:00:00	QQQ	ETF	30.62	30.62	30.62	30.62	3750.0
2009-03-24 05:00:00	QQQ	ETF	30.6	30.61	30.52	30.52	10640.0
2009-03-24 06:00:00	QQQ	ETF	30.53	30.61	30.51	30.6	4050.0
2009-03-24 07:00:00	QQQ	ETF	30.63	30.64	30.59	30.62	167091.0
2009-03-24 08:00:00	QQQ	ETF	30.63	30.67	30.58	30.63	1063970.0
2009-03-24 09:00:00	QQQ	ETF	30.62	30.7385	30.5	30.6499	14007743.0
2009-03-24 10:00:00	QQQ	ETF	30.65	30.79	30.34	30.431	24201161.0
2009-03-24 11:00:00	QQQ	ETF	30.44	30.65	30.4	30.47	12977285.0
2009-03-24 12:00:00	QQQ	ETF	30.48	30.79	30.41	30.76	11563304.0
2009-03-24 13:00:00	QQQ	ETF	30.77	30.88	30.56	30.65	13443710.0
2009-03-24 14:00:00	QQQ	ETF	30.65	30.79	30.51	30.57	12378318.0
2009-03-24 15:00:00	QQQ	ETF	30.57	30.61	30.31	30.33	16907552.0
2009-03-24 16:00:00	QQQ	ETF	30.34	30.9855	30.31	30.35	5951978.0
2009-03-24 17:00:00	QQQ	ETF	30.33	30.34	30.28	30.29	343614.0
2009-03-24 18:00:00	QQQ	ETF	30.33	30.9855	30.3	30.36	2044217.0
2009-03-24 19:00:00	QQQ	ETF	30.37	30.43	30.37	30.43	62350.0
2009-03-24 04:00:00	IWM	ETF	43.0	43.0	43.0	43.0	100.0
2009-03-24 06:00:00	IWM	ETF	42.75	42.86	42.75	42.86	3696.0
2009-03-24 07:00:00	IWM	ETF	42.78	42.85	42.75	42.79	62118.0
2009-03-24 08:00:00	IWM	ETF	42.78	42.95	42.55	42.7	318790.0
2009-03-24 09:00:00	IWM	ETF	42.7	42.87	42.47	42.86	7802603.0
2009-03-24 10:00:00	IWM	ETF	42.86	43.11	42.155	42.36	11170225.0
2009-03-24 11:00:00	IWM	ETF	42.37	42.75	42.31	42.35	6654146.0
2009-03-24 12:00:00	IWM	ETF	42.34	42.66	42.162	42.6089	6037818.0
2009-03-24 13:00:00	IWM	ETF	42.61	42.85	42.41	42.5	6908578.0
2009-03-24 14:00:00	IWM	ETF	42.5	42.69	42.31	42.34	6893910.0
2009-03-24 15:00:00	IWM	ETF	42.35	42.45	41.52	41.53	15017905.0
2009-03-24 16:00:00	IWM	ETF	41.53	42.0	41.51	41.56	2631515.0
2009-03-24 17:00:00	IWM	ETF	41.57	43.3203	41.41	41.5	2858699.0
2009-03-24 18:00:00	IWM	ETF	41.5	41.69	41.45	41.65	10142.0
2009-03-24 19:00:00	IWM	ETF	41.65	41.67	41.65	41.67	590.0
2009-03-24 06:00:00	DIA	ETF	77.03	77.03	76.93	76.93	1100.0
2009-03-24 07:00:00	DIA	ETF	77.09	77.15	76.99	77.08	38627.0
2009-03-24 08:00:00	DIA	ETF	77.07	77.14	76.89	77.03	79185.0

> showing 50 of 4,090 rows — these rows as CSV

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