PREVIEW / etf_1hour / 2010-02-10

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-02-10.parquet
  size:    151 KB
  rows:    4,677

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-02-10 04:00:00	SPY	ETF	106.93	107.11	106.83	107.11	7100.0
2010-02-10 05:00:00	SPY	ETF	107.12	107.69	107.12	107.61	80071.0
2010-02-10 06:00:00	SPY	ETF	107.48	107.6	107.4	107.54	90400.0
2010-02-10 07:00:00	SPY	ETF	107.49	107.75	107.1	107.15	1628557.0
2010-02-10 08:00:00	SPY	ETF	107.53	107.53	106.96	107.15	6350620.0
2010-02-10 09:00:00	SPY	ETF	107.15	107.45	106.87	107.1	22980945.0
2010-02-10 10:00:00	SPY	ETF	107.09	107.15	106.11	106.6283	58302408.0
2010-02-10 11:00:00	SPY	ETF	106.63	106.98	106.39	106.71	32164699.0
2010-02-10 12:00:00	SPY	ETF	106.7	107.39	106.6	107.17	24514028.0
2010-02-10 13:00:00	SPY	ETF	107.17	107.6	107.15	107.33	23151162.0
2010-02-10 14:00:00	SPY	ETF	107.33	107.48	106.98	107.1	23012004.0
2010-02-10 15:00:00	SPY	ETF	107.0995	107.32	106.82	107.0	33234756.0
2010-02-10 16:00:00	SPY	ETF	107.02	107.25	106.29	106.84	10076255.0
2010-02-10 17:00:00	SPY	ETF	106.87	106.92	106.78	106.9	449388.0
2010-02-10 18:00:00	SPY	ETF	106.9	106.93	106.86	106.9	33360.0
2010-02-10 19:00:00	SPY	ETF	106.93	107.24	106.93	107.2	140688.0
2010-02-10 04:00:00	QQQ	ETF	43.12	43.12	43.12	43.12	1000.0
2010-02-10 05:00:00	QQQ	ETF	43.32	43.33	43.32	43.33	989.0
2010-02-10 06:00:00	QQQ	ETF	43.34	43.34	43.25	43.27	3600.0
2010-02-10 07:00:00	QQQ	ETF	43.26	43.37	43.13	43.13	267959.0
2010-02-10 08:00:00	QQQ	ETF	43.17	43.35	43.09	43.19	1806025.0
2010-02-10 09:00:00	QQQ	ETF	43.18	43.31	43.04	43.16	10973886.0
2010-02-10 10:00:00	QQQ	ETF	43.16	43.18	42.75	42.91	21164897.0
2010-02-10 11:00:00	QQQ	ETF	42.91	43.02	42.82	42.91	10129081.0
2010-02-10 12:00:00	QQQ	ETF	42.91	43.16	42.86	43.11	11647247.0
2010-02-10 13:00:00	QQQ	ETF	43.11	43.26	42.95	43.16	9097017.0
2010-02-10 14:00:00	QQQ	ETF	43.16	43.22	43.04	43.09	7008393.0
2010-02-10 15:00:00	QQQ	ETF	43.09	43.16	42.98	43.02	10791387.0
2010-02-10 16:00:00	QQQ	ETF	43.02	43.1429	42.94	43.01	9343541.0
2010-02-10 17:00:00	QQQ	ETF	42.98	43.1363	42.96	42.99	1016860.0
2010-02-10 18:00:00	QQQ	ETF	42.99	43.02	42.99	43.01	8678.0
2010-02-10 19:00:00	QQQ	ETF	43.01	43.14	43.01	43.11	60789.0
2010-02-10 07:00:00	IWM	ETF	59.52	59.7	59.25	59.28	126894.0
2010-02-10 08:00:00	IWM	ETF	59.71	59.71	59.25	59.39	409521.0
2010-02-10 09:00:00	IWM	ETF	59.36	59.55	59.07	59.25	5584984.0
2010-02-10 10:00:00	IWM	ETF	59.25	59.27	58.69	59.1	12243770.0
2010-02-10 11:00:00	IWM	ETF	59.11	59.19	58.89	59.05	6419561.0
2010-02-10 12:00:00	IWM	ETF	59.059	59.5	59.0	59.465	6036540.0
2010-02-10 13:00:00	IWM	ETF	59.46	59.78	59.45	59.56	5457418.0
2010-02-10 14:00:00	IWM	ETF	59.565	59.68	59.48	59.53	3567660.0
2010-02-10 15:00:00	IWM	ETF	59.54	59.65	59.37	59.59	7943463.0
2010-02-10 16:00:00	IWM	ETF	59.5902	59.64	59.1748	59.46	4003621.0
2010-02-10 17:00:00	IWM	ETF	59.48	59.55	59.45	59.5	214330.0
2010-02-10 18:00:00	IWM	ETF	59.5	59.55	59.5	59.5	700.0
2010-02-10 19:00:00	IWM	ETF	59.5	59.69	59.5	59.66	11800.0
2010-02-10 07:00:00	DIA	ETF	100.8	101.1	100.75	100.75	2050.0
2010-02-10 08:00:00	DIA	ETF	100.68	100.68	100.47	100.62	79000.0
2010-02-10 09:00:00	DIA	ETF	100.62	100.89	100.36	100.58	1355665.0
2010-02-10 10:00:00	DIA	ETF	100.61	100.61	99.75	100.15	2326160.0
2010-02-10 11:00:00	DIA	ETF	100.15	100.5	100.0	100.2864	1407709.0

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

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