PREVIEW / etf_1hour / 2010-05-25

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-05-25.parquet
  size:    177 KB
  rows:    5,447

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
2010-05-25 04:00:00	SPY	ETF	105.07	105.21	104.73	104.73	27557.0
2010-05-25 05:00:00	SPY	ETF	104.84	105.18	104.8	104.8	125272.0
2010-05-25 06:00:00	SPY	ETF	104.68	105.2	104.27	105.17	574195.0
2010-05-25 07:00:00	SPY	ETF	105.2	105.2	104.56	105.03	1950008.0
2010-05-25 08:00:00	SPY	ETF	105.05	106.9875	104.61	104.88	6509191.0
2010-05-25 09:00:00	SPY	ETF	104.98	105.43	104.38	105.21	61289344.0
2010-05-25 10:00:00	SPY	ETF	105.21	105.95	104.9279	105.47	61038605.0
2010-05-25 11:00:00	SPY	ETF	105.47	106.16	105.42	106.08	42256585.0
2010-05-25 12:00:00	SPY	ETF	106.08	106.37	105.61	105.91	34069340.0
2010-05-25 13:00:00	SPY	ETF	105.9	106.1286	105.42	105.62	29459174.0
2010-05-25 14:00:00	SPY	ETF	105.62	106.88	105.44	106.59	45078567.0
2010-05-25 15:00:00	SPY	ETF	106.59	107.87	105.9	107.8075	82615103.0
2010-05-25 16:00:00	SPY	ETF	107.82	108.17	104.45	108.13	22877602.0
2010-05-25 17:00:00	SPY	ETF	108.13	108.95	108.13	108.75	1032741.0
2010-05-25 18:00:00	SPY	ETF	108.74	108.83	108.42	108.54	544331.0
2010-05-25 19:00:00	SPY	ETF	108.51	108.79	108.49	108.7	154507.0
2010-05-25 04:00:00	QQQ	ETF	43.74	43.8	43.74	43.8	3642.0
2010-05-25 05:00:00	QQQ	ETF	43.64	43.66	43.58	43.6	30733.0
2010-05-25 06:00:00	QQQ	ETF	43.59	43.79	43.37	43.79	25755.0
2010-05-25 07:00:00	QQQ	ETF	43.8	43.8	43.55	43.77	79115.0
2010-05-25 08:00:00	QQQ	ETF	43.77	44.66	43.61	43.63	1216704.0
2010-05-25 09:00:00	QQQ	ETF	43.64	44.66	43.23	43.54	26126018.0
2010-05-25 10:00:00	QQQ	ETF	43.53	43.92	43.49	43.7301	28851511.0
2010-05-25 11:00:00	QQQ	ETF	43.73	44.04	43.7	44.02	14413746.0
2010-05-25 12:00:00	QQQ	ETF	44.03	44.18	43.82	43.98	9888092.0
2010-05-25 13:00:00	QQQ	ETF	43.97	43.99	43.74	43.81	10175073.0
2010-05-25 14:00:00	QQQ	ETF	43.82	44.38	43.74	44.24	17625284.0
2010-05-25 15:00:00	QQQ	ETF	44.24	44.76	43.72	44.71	37722629.0
2010-05-25 16:00:00	QQQ	ETF	44.71	44.88	43.7	44.88	5093618.0
2010-05-25 17:00:00	QQQ	ETF	44.88	45.16	44.87	45.05	300108.0
2010-05-25 18:00:00	QQQ	ETF	45.09	45.13	44.97	45.06	151940.0
2010-05-25 19:00:00	QQQ	ETF	45.04	45.14	45.04	45.14	75639.0
2010-05-25 04:00:00	IWM	ETF	62.74	62.74	62.74	62.74	230.0
2010-05-25 05:00:00	IWM	ETF	62.53	62.53	62.53	62.53	400.0
2010-05-25 06:00:00	IWM	ETF	62.19	62.72	62.19	62.72	31200.0
2010-05-25 07:00:00	IWM	ETF	62.76	62.76	62.27	62.7	498517.0
2010-05-25 08:00:00	IWM	ETF	62.7	63.25	62.45	62.56	942398.0
2010-05-25 09:00:00	IWM	ETF	62.55	64.2	61.71	62.09	16638786.0
2010-05-25 10:00:00	IWM	ETF	62.09	62.84	62.0	62.61	18886330.0
2010-05-25 11:00:00	IWM	ETF	62.62	63.13	62.38	63.02	13293566.0
2010-05-25 12:00:00	IWM	ETF	63.01	63.3	62.74	62.96	9831433.0
2010-05-25 13:00:00	IWM	ETF	62.96	63.02	62.62	62.7	7054554.0
2010-05-25 14:00:00	IWM	ETF	62.712	63.54	62.6	63.23	11064496.0
2010-05-25 15:00:00	IWM	ETF	63.23	64.24	63.21	64.2	24043243.0
2010-05-25 16:00:00	IWM	ETF	64.19	64.23	61.9797	64.23	3539065.0
2010-05-25 17:00:00	IWM	ETF	64.27	64.73	64.25	64.65	149819.0
2010-05-25 18:00:00	IWM	ETF	64.64	64.7	64.54	64.64	32930.0
2010-05-25 19:00:00	IWM	ETF	64.64	64.7	64.52	64.7	8455.0
2010-05-25 04:00:00	DIA	ETF	98.6	98.6	98.6	98.6	200.0
2010-05-25 06:00:00	DIA	ETF	98.6	98.6	98.6	98.6	200.0

> showing 50 of 5,447 rows — these rows as CSV

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