PREVIEW / etf_1hour / 2009-02-25

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-02-25.parquet
  size:    127 KB
  rows:    3,933

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-02-25 04:00:00	SPY	ETF	77.05	77.14	77.03	77.03	3900.0
2009-02-25 05:00:00	SPY	ETF	77.54	77.54	77.51	77.51	1500.0
2009-02-25 06:00:00	SPY	ETF	77.4	77.61	76.81	76.96	40800.0
2009-02-25 07:00:00	SPY	ETF	76.91	77.29	76.79	77.21	526464.0
2009-02-25 08:00:00	SPY	ETF	77.19	77.54	76.78	77.02	2359261.0
2009-02-25 09:00:00	SPY	ETF	77.0	77.36	76.43	76.59	37627736.0
2009-02-25 10:00:00	SPY	ETF	76.67	76.67	75.63	75.87	80333511.0
2009-02-25 11:00:00	SPY	ETF	75.87	77.02	75.83	76.33	59428641.0
2009-02-25 12:00:00	SPY	ETF	76.33	76.52	75.75	76.11	42551508.0
2009-02-25 13:00:00	SPY	ETF	76.11	77.57	76.04	77.4	47556811.0
2009-02-25 14:00:00	SPY	ETF	77.39	77.54	76.23	77.23	88923050.0
2009-02-25 15:00:00	SPY	ETF	77.23	78.42	76.79	76.85	87513936.0
2009-02-25 16:00:00	SPY	ETF	76.86	78.2779	76.1	76.63	10647423.0
2009-02-25 17:00:00	SPY	ETF	76.61	77.6978	76.58	76.85	3822642.0
2009-02-25 18:00:00	SPY	ETF	76.88	76.95	76.78	76.83	124435.0
2009-02-25 19:00:00	SPY	ETF	76.87	77.35	76.87	77.35	174248.0
2009-02-25 06:00:00	QQQ	ETF	28.6	28.6	28.53	28.53	800.0
2009-02-25 07:00:00	QQQ	ETF	28.51	28.63	28.47	28.62	298053.0
2009-02-25 08:00:00	QQQ	ETF	28.62	28.77	28.57	28.59	1222377.0
2009-02-25 09:00:00	QQQ	ETF	28.61	28.69	28.49	28.55	25189769.0
2009-02-25 10:00:00	QQQ	ETF	28.54	28.56	28.14	28.27	43809928.0
2009-02-25 11:00:00	QQQ	ETF	28.2795	28.65	28.26	28.36	22193309.0
2009-02-25 12:00:00	QQQ	ETF	28.36	28.438	28.24	28.38	14835163.0
2009-02-25 13:00:00	QQQ	ETF	28.37	28.8	28.35	28.745	22817427.0
2009-02-25 14:00:00	QQQ	ETF	28.74	28.8	28.43	28.69	35109986.0
2009-02-25 15:00:00	QQQ	ETF	28.68	29.17	28.58	28.59	44582041.0
2009-02-25 16:00:00	QQQ	ETF	28.59	28.61	28.41	28.47	4117369.0
2009-02-25 17:00:00	QQQ	ETF	28.46	28.56	28.46	28.49	108636.0
2009-02-25 18:00:00	QQQ	ETF	28.53	28.55	28.5	28.52	53256.0
2009-02-25 19:00:00	QQQ	ETF	28.5	28.68	28.5	28.68	80500.0
2009-02-25 06:00:00	IWM	ETF	41.2	41.2	40.75	40.8	8119.0
2009-02-25 07:00:00	IWM	ETF	40.8	40.92	40.8	40.87	7431.0
2009-02-25 08:00:00	IWM	ETF	40.96	41.05	40.75	40.79	171778.0
2009-02-25 09:00:00	IWM	ETF	40.82	40.97	40.33	40.45	10397505.0
2009-02-25 10:00:00	IWM	ETF	40.45	40.46	39.74	39.86	16866260.0
2009-02-25 11:00:00	IWM	ETF	39.86	40.5	39.77	39.82	12634978.0
2009-02-25 12:00:00	IWM	ETF	39.82	39.91	39.49	39.69	11514685.0
2009-02-25 13:00:00	IWM	ETF	39.68	40.42	39.58	40.28	7362471.0
2009-02-25 14:00:00	IWM	ETF	40.29	40.44	39.77	40.31	14214446.0
2009-02-25 15:00:00	IWM	ETF	40.3	41.13	39.75	40.13	20825468.0
2009-02-25 16:00:00	IWM	ETF	40.12	41.05	39.79	39.94	4491908.0
2009-02-25 17:00:00	IWM	ETF	39.93	41.2532	39.81	40.05	2265479.0
2009-02-25 18:00:00	IWM	ETF	40.05	40.23	40.05	40.23	400.0
2009-02-25 19:00:00	IWM	ETF	40.16	40.16	40.16	40.16	100.0
2009-02-25 05:00:00	DIA	ETF	73.25	73.3	73.25	73.3	300.0
2009-02-25 06:00:00	DIA	ETF	73.25	73.25	72.69	72.8	4781.0
2009-02-25 07:00:00	DIA	ETF	72.75	72.99	72.71	72.95	17900.0
2009-02-25 08:00:00	DIA	ETF	73.06	73.25	72.77	72.87	35066.0
2009-02-25 09:00:00	DIA	ETF	72.87	73.23	72.52	72.55	4061134.0
2009-02-25 10:00:00	DIA	ETF	72.56	72.57	71.56	71.74	7789172.0

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

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