PREVIEW / etf_1hour / 2008-02-14

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-02-14.parquet
  size:    98 KB
  rows:    3,270

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-02-14 04:00:00	SPY	ETF	136.75	136.77	136.75	136.77	200.0
2008-02-14 05:00:00	SPY	ETF	136.54	136.79	136.52	136.74	16600.0
2008-02-14 06:00:00	SPY	ETF	136.67	136.84	136.67	136.7	27300.0
2008-02-14 07:00:00	SPY	ETF	136.75	136.89	136.56	136.62	475200.0
2008-02-14 08:00:00	SPY	ETF	136.64	137.03	136.46	136.79	2373800.0
2008-02-14 09:00:00	SPY	ETF	136.8	137.04	136.22	136.46	19901536.0
2008-02-14 10:00:00	SPY	ETF	136.46	136.98	136.17	136.22	25636703.0
2008-02-14 11:00:00	SPY	ETF	136.22	136.3	135.46	135.7799	33109721.0
2008-02-14 12:00:00	SPY	ETF	135.78	136.12	135.46	135.52	24523859.0
2008-02-14 13:00:00	SPY	ETF	135.51	135.68	135.25	135.59	24200420.0
2008-02-14 14:00:00	SPY	ETF	135.5801	135.81	134.79	135.33	29272646.0
2008-02-14 15:00:00	SPY	ETF	135.34	135.89	134.9	135.01	49068144.0
2008-02-14 16:00:00	SPY	ETF	135.01	136.17	135.0	135.07	3019730.0
2008-02-14 17:00:00	SPY	ETF	135.1	135.19	135.01	135.13	1000000.0
2008-02-14 18:00:00	SPY	ETF	135.08	135.15	134.88	134.95	54100.0
2008-02-14 19:00:00	SPY	ETF	134.9	135.05	134.83	134.93	41600.0
2008-02-14 05:00:00	QQQ	ETF	44.75	44.86	44.74	44.86	23000.0
2008-02-14 06:00:00	QQQ	ETF	44.86	44.86	44.86	44.86	100.0
2008-02-14 07:00:00	QQQ	ETF	44.9	44.91	44.78	44.84	176196.0
2008-02-14 08:00:00	QQQ	ETF	44.84	44.93	44.81	44.87	1388309.0
2008-02-14 09:00:00	QQQ	ETF	44.9	44.92	44.41	44.61	34712162.0
2008-02-14 10:00:00	QQQ	ETF	44.61	44.73	44.45	44.45	17536870.0
2008-02-14 11:00:00	QQQ	ETF	44.46	44.52	44.19	44.28	20305336.0
2008-02-14 12:00:00	QQQ	ETF	44.29	44.4	44.15	44.18	17415387.0
2008-02-14 13:00:00	QQQ	ETF	44.18	44.24	44.06	44.205	20350104.0
2008-02-14 14:00:00	QQQ	ETF	44.21	44.26	43.89	44.01	21252285.0
2008-02-14 15:00:00	QQQ	ETF	44.0	44.21	43.91	43.9799	31148864.0
2008-02-14 16:00:00	QQQ	ETF	43.97	44.1	43.92	43.97	5198313.0
2008-02-14 17:00:00	QQQ	ETF	43.94	44.8374	43.84	43.9	3504987.0
2008-02-14 18:00:00	QQQ	ETF	43.92	43.97	43.86	43.88	118438.0
2008-02-14 19:00:00	QQQ	ETF	43.89	43.93	43.85	43.85	28544.0
2008-02-14 04:00:00	IWM	ETF	72.04	72.04	72.04	72.04	1100.0
2008-02-14 07:00:00	IWM	ETF	72.02	72.05	71.93	71.93	105900.0
2008-02-14 08:00:00	IWM	ETF	71.9	72.11	71.75	72.1	308800.0
2008-02-14 09:00:00	IWM	ETF	72.1	72.21	71.19	71.62	7947290.0
2008-02-14 10:00:00	IWM	ETF	71.63	71.87	70.0	71.28	6995495.0
2008-02-14 11:00:00	IWM	ETF	71.26	71.33	70.62	70.73	15880644.0
2008-02-14 12:00:00	IWM	ETF	70.73	70.96	70.4	70.66	15072289.0
2008-02-14 13:00:00	IWM	ETF	70.66	70.72	70.33	70.58	8487572.0
2008-02-14 14:00:00	IWM	ETF	70.59	70.7	70.02	70.31	9374208.0
2008-02-14 15:00:00	IWM	ETF	70.31	70.86	70.14	70.28	13258250.0
2008-02-14 16:00:00	IWM	ETF	70.27	70.93	70.01	70.18	2226200.0
2008-02-14 17:00:00	IWM	ETF	70.21	70.27	70.1	70.1	104700.0
2008-02-14 18:00:00	IWM	ETF	70.2	70.2	70.03	70.08	58700.0
2008-02-14 19:00:00	IWM	ETF	70.1	70.13	70.03	70.03	4500.0
2008-02-14 07:00:00	DIA	ETF	125.6	125.6	125.58	125.58	300.0
2008-02-14 08:00:00	DIA	ETF	125.49	125.68	125.34	125.57	26100.0
2008-02-14 09:00:00	DIA	ETF	125.64	125.76	125.08	125.16	1261863.0
2008-02-14 10:00:00	DIA	ETF	125.16	125.51	124.88	124.93	1659440.0
2008-02-14 11:00:00	DIA	ETF	124.89	124.99	124.35	124.65	1942867.0

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

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