PREVIEW / etf_1hour / 2010-04-07

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-04-07.parquet
  size:    157 KB
  rows:    4,852

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-04-07 04:00:00	SPY	ETF	118.71	118.72	118.65	118.66	1750.0
2010-04-07 05:00:00	SPY	ETF	118.85	118.86	118.81	118.84	3200.0
2010-04-07 06:00:00	SPY	ETF	118.81	118.85	118.73	118.73	17360.0
2010-04-07 07:00:00	SPY	ETF	118.73	118.75	118.63	118.63	182041.0
2010-04-07 08:00:00	SPY	ETF	118.65	118.7	118.46	118.67	1347848.0
2010-04-07 09:00:00	SPY	ETF	118.67	118.97	118.62	118.81	19680368.0
2010-04-07 10:00:00	SPY	ETF	118.81	118.94	118.38	118.51	27728455.0
2010-04-07 11:00:00	SPY	ETF	118.51	118.82	118.36	118.74	21169706.0
2010-04-07 12:00:00	SPY	ETF	118.74	119.3567	118.63	118.8	8364616.0
2010-04-07 13:00:00	SPY	ETF	118.8	119.08	118.78	118.91	18401869.0
2010-04-07 14:00:00	SPY	ETF	118.92	118.92	118.34	118.43	23076651.0
2010-04-07 15:00:00	SPY	ETF	118.42	118.43	117.81	118.38	47714721.0
2010-04-07 16:00:00	SPY	ETF	118.38	118.96	118.0	118.36	10352673.0
2010-04-07 17:00:00	SPY	ETF	118.37	119.0471	118.29	118.35	1167686.0
2010-04-07 18:00:00	SPY	ETF	118.33	118.37	118.3	118.3	58110.0
2010-04-07 19:00:00	SPY	ETF	118.3	118.3	118.2	118.21	93178.0
2010-04-07 07:00:00	QQQ	ETF	48.64	48.64	48.6	48.62	22060.0
2010-04-07 08:00:00	QQQ	ETF	48.62	48.64	48.55	48.63	321828.0
2010-04-07 09:00:00	QQQ	ETF	48.63	48.77	48.6	48.69	9914432.0
2010-04-07 10:00:00	QQQ	ETF	48.69	48.858	48.59	48.67	12946286.0
2010-04-07 11:00:00	QQQ	ETF	48.67	48.79	48.61	48.76	7559111.0
2010-04-07 12:00:00	QQQ	ETF	48.76	48.79	48.71	48.79	2349749.0
2010-04-07 13:00:00	QQQ	ETF	48.79	48.87	48.74	48.8	7233028.0
2010-04-07 14:00:00	QQQ	ETF	48.81	48.82	48.59	48.631	7792875.0
2010-04-07 15:00:00	QQQ	ETF	48.63	48.64	48.37	48.64	18202872.0
2010-04-07 16:00:00	QQQ	ETF	48.63	48.858	48.4916	48.64	2872780.0
2010-04-07 17:00:00	QQQ	ETF	48.62	48.64	48.62	48.63	28139.0
2010-04-07 18:00:00	QQQ	ETF	48.63	48.63	48.62	48.62	12100.0
2010-04-07 19:00:00	QQQ	ETF	48.62	48.62	48.59	48.61	81214.0
2010-04-07 06:00:00	IWM	ETF	69.94	69.96	69.94	69.96	1100.0
2010-04-07 07:00:00	IWM	ETF	69.91	69.93	69.88	69.88	47763.0
2010-04-07 08:00:00	IWM	ETF	69.89	69.91	69.76	69.9	242335.0
2010-04-07 09:00:00	IWM	ETF	69.89	70.21	69.85	70.06	5232652.0
2010-04-07 10:00:00	IWM	ETF	70.06	70.19	69.79	69.91	7681253.0
2010-04-07 11:00:00	IWM	ETF	69.9	70.18	69.75	70.04	7537598.0
2010-04-07 12:00:00	IWM	ETF	70.05	70.08	69.94	70.05	4319799.0
2010-04-07 13:00:00	IWM	ETF	70.06	70.31	70.06	70.23	6724035.0
2010-04-07 14:00:00	IWM	ETF	70.24	70.27	69.88	69.95	7541633.0
2010-04-07 15:00:00	IWM	ETF	69.95	69.95	69.45	69.89	21492192.0
2010-04-07 16:00:00	IWM	ETF	69.89	70.1319	69.7603	69.91	6583592.0
2010-04-07 17:00:00	IWM	ETF	69.9	69.92	69.87	69.87	14380.0
2010-04-07 18:00:00	IWM	ETF	70.1319	70.1319	69.88	69.93	2253130.0
2010-04-07 19:00:00	IWM	ETF	69.89	69.93	69.84	69.84	1800.0
2010-04-07 04:00:00	DIA	ETF	109.62	109.62	109.62	109.62	750.0
2010-04-07 07:00:00	DIA	ETF	109.55	109.6	109.51	109.51	375.0
2010-04-07 08:00:00	DIA	ETF	109.49	109.49	109.34	109.48	28050.0
2010-04-07 09:00:00	DIA	ETF	109.52	109.64	109.36	109.49	753629.0
2010-04-07 10:00:00	DIA	ETF	109.5	109.58	109.03	109.17	2533455.0
2010-04-07 11:00:00	DIA	ETF	109.17	109.55	109.05	109.5	1660518.0
2010-04-07 12:00:00	DIA	ETF	109.49	109.54	109.33	109.44	777307.0

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

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