PREVIEW / etf_1hour / 2010-11-12

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-11-12.parquet
  size:    177 KB
  rows:    5,373

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-11-12 04:00:00	SPY	ETF	120.75	120.75	120.19	120.48	120434.0
2010-11-12 05:00:00	SPY	ETF	120.5	121.11	120.5	121.0	55993.0
2010-11-12 06:00:00	SPY	ETF	120.95	120.95	120.66	120.89	175000.0
2010-11-12 07:00:00	SPY	ETF	120.85	121.01	120.71	120.77	751261.0
2010-11-12 08:00:00	SPY	ETF	120.76	121.05	120.01	121.01	2180587.0
2010-11-12 09:00:00	SPY	ETF	121.01	121.35	120.71	121.22	27016118.0
2010-11-12 10:00:00	SPY	ETF	121.21	121.32	120.31	120.37	42027372.0
2010-11-12 11:00:00	SPY	ETF	120.38	120.8663	120.18	120.3225	25871706.0
2010-11-12 12:00:00	SPY	ETF	120.3299	120.41	119.68	119.7899	33578610.0
2010-11-12 13:00:00	SPY	ETF	119.79	120.1	119.65	119.79	22529848.0
2010-11-12 14:00:00	SPY	ETF	119.79	120.26	119.71	120.105	23564147.0
2010-11-12 15:00:00	SPY	ETF	120.1	120.41	119.95	120.2	48985912.0
2010-11-12 16:00:00	SPY	ETF	120.19	120.935	119.885	120.04	9359606.0
2010-11-12 17:00:00	SPY	ETF	120.04	120.04	119.9	119.91	257948.0
2010-11-12 18:00:00	SPY	ETF	119.92	120.18	119.9	119.96	109026.0
2010-11-12 19:00:00	SPY	ETF	119.93	119.97	119.85	119.85	29235.0
2010-11-12 04:00:00	QQQ	ETF	52.8	52.89	52.77	52.85	995.0
2010-11-12 05:00:00	QQQ	ETF	52.94	53.02	52.87	53.02	3699.0
2010-11-12 06:00:00	QQQ	ETF	52.95	53.06	52.91	53.06	262500.0
2010-11-12 07:00:00	QQQ	ETF	53.08	53.15	53.02	53.04	128511.0
2010-11-12 08:00:00	QQQ	ETF	53.06	53.13	52.98	53.11	1157298.0
2010-11-12 09:00:00	QQQ	ETF	53.11	53.32	53.06	53.26	12034575.0
2010-11-12 10:00:00	QQQ	ETF	53.27	53.285	52.73	52.75	16220532.0
2010-11-12 11:00:00	QQQ	ETF	52.75	52.87	52.64	52.7	9125650.0
2010-11-12 12:00:00	QQQ	ETF	52.69	52.72	52.11	52.265	15946356.0
2010-11-12 13:00:00	QQQ	ETF	52.27	52.491	52.21	52.34	8142978.0
2010-11-12 14:00:00	QQQ	ETF	52.33	52.65	52.3001	52.58	6900544.0
2010-11-12 15:00:00	QQQ	ETF	52.58	52.7	52.46	52.5	15264957.0
2010-11-12 16:00:00	QQQ	ETF	52.51	52.56	52.48	52.51	1669484.0
2010-11-12 17:00:00	QQQ	ETF	52.51	52.52	52.42	52.42	18584.0
2010-11-12 18:00:00	QQQ	ETF	52.45	52.5	52.39	52.44	19451.0
2010-11-12 19:00:00	QQQ	ETF	52.4	52.41	52.34	52.39	20605.0
2010-11-12 04:00:00	IWM	ETF	73.1	73.1	72.23	72.38	1660.0
2010-11-12 05:00:00	IWM	ETF	72.4	72.56	72.4	72.56	3200.0
2010-11-12 06:00:00	IWM	ETF	72.6	72.63	72.54	72.61	900.0
2010-11-12 07:00:00	IWM	ETF	72.66	72.72	72.55	72.57	54509.0
2010-11-12 08:00:00	IWM	ETF	71.97	72.74	71.97	72.69	208965.0
2010-11-12 09:00:00	IWM	ETF	72.73	73.1	72.5	72.94	5652570.0
2010-11-12 10:00:00	IWM	ETF	72.94	73.03	72.26	72.33	7177381.0
2010-11-12 11:00:00	IWM	ETF	72.33	72.62	72.21	72.35	5175148.0
2010-11-12 12:00:00	IWM	ETF	72.35	72.43	71.9	72.031	7083259.0
2010-11-12 13:00:00	IWM	ETF	72.04	72.24	71.942	72.0401	3915867.0
2010-11-12 14:00:00	IWM	ETF	72.04	72.33	71.97	72.2	3863400.0
2010-11-12 15:00:00	IWM	ETF	72.2	72.45	72.01	72.02	10384340.0
2010-11-12 16:00:00	IWM	ETF	72.02	73.2226	71.88	72.01	3684183.0
2010-11-12 17:00:00	IWM	ETF	72.01	72.01	71.91	71.91	14952.0
2010-11-12 18:00:00	IWM	ETF	71.92	72.0	71.82	71.86	37272.0
2010-11-12 19:00:00	IWM	ETF	71.9	71.9	71.81	71.81	13369.0
2010-11-12 05:00:00	DIA	ETF	112.3	112.3	112.3	112.3	100.0
2010-11-12 07:00:00	DIA	ETF	112.46	112.5	112.45	112.5	5200.0

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

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