PREVIEW / etf_1hour / 2009-10-27

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-10-27.parquet
  size:    144 KB
  rows:    4,423

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-10-27 04:00:00	SPY	ETF	107.21	107.21	107.21	107.21	260.0
2009-10-27 05:00:00	SPY	ETF	106.96	107.06	106.96	107.06	3700.0
2009-10-27 06:00:00	SPY	ETF	107.14	107.27	107.06	107.27	16016.0
2009-10-27 07:00:00	SPY	ETF	107.24	107.43	107.1	107.25	216630.0
2009-10-27 08:00:00	SPY	ETF	107.25	107.32	106.95	107.16	1576782.0
2009-10-27 09:00:00	SPY	ETF	107.17	107.34	106.65	106.93	31634441.0
2009-10-27 10:00:00	SPY	ETF	106.93	107.39	106.16	107.0705	66132789.0
2009-10-27 11:00:00	SPY	ETF	107.07	107.24	106.76	107.16	19043184.0
2009-10-27 12:00:00	SPY	ETF	107.16	107.21	106.68	106.73	17355417.0
2009-10-27 13:00:00	SPY	ETF	106.73	106.87	106.18	106.45	27265151.0
2009-10-27 14:00:00	SPY	ETF	106.455	107.01	106.25	106.88	20990366.0
2009-10-27 15:00:00	SPY	ETF	106.88	106.95	106.3	106.42	41160776.0
2009-10-27 16:00:00	SPY	ETF	106.42	107.15	106.31	106.64	21031161.0
2009-10-27 17:00:00	SPY	ETF	106.64	106.68	106.45	106.57	2264325.0
2009-10-27 18:00:00	SPY	ETF	106.62	106.816	106.61	106.76	681235.0
2009-10-27 19:00:00	SPY	ETF	106.73	106.75	106.67	106.75	44421.0
2009-10-27 20:00:00	SPY	ETF	106.75	106.75	106.75	106.75	500.0
2009-10-27 04:00:00	QQQ	ETF	43.04	43.05	42.99	42.99	1400.0
2009-10-27 06:00:00	QQQ	ETF	43.02	43.05	43.02	43.05	1500.0
2009-10-27 07:00:00	QQQ	ETF	43.06	43.12	43.0	43.03	141405.0
2009-10-27 08:00:00	QQQ	ETF	43.05	43.05	42.92	42.98	202865.0
2009-10-27 09:00:00	QQQ	ETF	42.99	43.11	42.74	42.74	15631514.0
2009-10-27 10:00:00	QQQ	ETF	42.85	43.03	42.38	42.83	35073205.0
2009-10-27 11:00:00	QQQ	ETF	42.83	42.86	42.65	42.72	8397156.0
2009-10-27 12:00:00	QQQ	ETF	42.72	42.7399	42.51	42.53	7140189.0
2009-10-27 13:00:00	QQQ	ETF	42.53	42.57	42.18	42.3305	19493143.0
2009-10-27 14:00:00	QQQ	ETF	42.34	42.56	42.25	42.51	11589426.0
2009-10-27 15:00:00	QQQ	ETF	42.51	42.53	42.29	42.35	19493638.0
2009-10-27 16:00:00	QQQ	ETF	42.34	42.62	42.3	42.38	3700340.0
2009-10-27 17:00:00	QQQ	ETF	42.39	42.41	42.36	42.39	78664.0
2009-10-27 18:00:00	QQQ	ETF	42.39	42.43	42.37	42.43	34967.0
2009-10-27 19:00:00	QQQ	ETF	42.43	42.43	42.41	42.42	31917.0
2009-10-27 07:00:00	IWM	ETF	59.92	59.93	59.7	59.75	36900.0
2009-10-27 08:00:00	IWM	ETF	59.8	59.87	59.58	59.74	3982983.0
2009-10-27 09:00:00	IWM	ETF	59.73	59.89	59.36	59.62	12631662.0
2009-10-27 10:00:00	IWM	ETF	59.6	59.81	58.82	59.54	17314730.0
2009-10-27 11:00:00	IWM	ETF	59.53	59.63	59.22	59.52	5845741.0
2009-10-27 12:00:00	IWM	ETF	59.52	59.56	59.22	59.22	3477929.0
2009-10-27 13:00:00	IWM	ETF	59.22	59.315	58.75	58.98	7153861.0
2009-10-27 14:00:00	IWM	ETF	58.98	59.36	58.805	59.2499	4796325.0
2009-10-27 15:00:00	IWM	ETF	59.24	59.275	58.69	58.77	10111537.0
2009-10-27 16:00:00	IWM	ETF	58.76	59.4025	58.61	58.84	1715750.0
2009-10-27 17:00:00	IWM	ETF	58.83	58.87	58.82	58.83	16650.0
2009-10-27 18:00:00	IWM	ETF	58.91	58.92	58.91	58.92	1100.0
2009-10-27 04:00:00	DIA	ETF	100.0	102.1	100.0	102.1	666.0
2009-10-27 07:00:00	DIA	ETF	99.18	99.29	99.04	99.19	11666.0
2009-10-27 08:00:00	DIA	ETF	99.06	99.15	98.88	99.02	12963.0
2009-10-27 09:00:00	DIA	ETF	99.06	99.34	98.8	98.8	2121319.0
2009-10-27 10:00:00	DIA	ETF	99.0	99.53	98.4	99.3	4167820.0
2009-10-27 11:00:00	DIA	ETF	99.32	99.47	99.09	99.4	1432586.0

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

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