PREVIEW / etf_1hour / 2010-01-28

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-01-28.parquet
  size:    157 KB
  rows:    4,832

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-01-28 04:00:00	SPY	ETF	110.38	110.5	110.36	110.5	2500.0
2010-01-28 05:00:00	SPY	ETF	110.5	110.5	110.07	110.2	35600.0
2010-01-28 06:00:00	SPY	ETF	110.18	110.3	110.08	110.15	21450.0
2010-01-28 07:00:00	SPY	ETF	110.2	110.63	110.14	110.41	730758.0
2010-01-28 08:00:00	SPY	ETF	110.39	110.85	109.92	110.21	5136471.0
2010-01-28 09:00:00	SPY	ETF	110.2	110.38	109.44	109.7	30880541.0
2010-01-28 10:00:00	SPY	ETF	109.71	109.725	108.86	109.01	46385508.0
2010-01-28 11:00:00	SPY	ETF	109.0	109.05	107.91	108.34	52798448.0
2010-01-28 12:00:00	SPY	ETF	108.34	108.54	108.05	108.53	22035379.0
2010-01-28 13:00:00	SPY	ETF	108.53	109.8639	108.43	108.74	38889024.0
2010-01-28 14:00:00	SPY	ETF	108.74	108.96	108.32	108.8	32173761.0
2010-01-28 15:00:00	SPY	ETF	108.8	109.36	108.54	108.56	61118101.0
2010-01-28 16:00:00	SPY	ETF	108.56	109.63	108.19	108.66	21152533.0
2010-01-28 17:00:00	SPY	ETF	108.7	108.73	108.46	108.55	3782339.0
2010-01-28 18:00:00	SPY	ETF	108.52	108.53	108.15	108.26	465864.0
2010-01-28 19:00:00	SPY	ETF	108.28	108.28	108.01	108.11	114488.0
2010-01-28 05:00:00	QQQ	ETF	44.72	44.72	44.52	44.58	12240.0
2010-01-28 06:00:00	QQQ	ETF	44.58	44.61	44.53	44.61	11800.0
2010-01-28 07:00:00	QQQ	ETF	44.56	44.77	44.54	44.68	1359465.0
2010-01-28 08:00:00	QQQ	ETF	44.68	44.85	44.47	44.49	4838357.0
2010-01-28 09:00:00	QQQ	ETF	44.49	44.52	44.0125	44.1699	24057940.0
2010-01-28 10:00:00	QQQ	ETF	44.18	44.18	43.62	43.68	35583531.0
2010-01-28 11:00:00	QQQ	ETF	43.68	43.7	43.35	43.47	37428794.0
2010-01-28 12:00:00	QQQ	ETF	43.48	43.53	43.32	43.5	13434257.0
2010-01-28 13:00:00	QQQ	ETF	43.51	43.67	43.42	43.54	15289339.0
2010-01-28 14:00:00	QQQ	ETF	43.545	43.7556	43.36	43.6699	16123423.0
2010-01-28 15:00:00	QQQ	ETF	43.66	43.84	43.55	43.55	26519512.0
2010-01-28 16:00:00	QQQ	ETF	43.56	44.7219	43.54	43.79	27941013.0
2010-01-28 17:00:00	QQQ	ETF	44.7219	44.7219	43.5492	43.67	5527400.0
2010-01-28 18:00:00	QQQ	ETF	43.68	43.75	43.5	43.52	242517.0
2010-01-28 19:00:00	QQQ	ETF	43.52	43.52	43.4	43.45	32999.0
2010-01-28 07:00:00	IWM	ETF	62.09	62.34	62.09	62.19	62250.0
2010-01-28 08:00:00	IWM	ETF	62.18	62.4	62.05	62.08	339857.0
2010-01-28 09:00:00	IWM	ETF	62.08	62.14	61.4	61.57	11426250.0
2010-01-28 10:00:00	IWM	ETF	61.57	61.57	61.07	61.15	10847184.0
2010-01-28 11:00:00	IWM	ETF	61.15	61.16	60.22	60.57	18884493.0
2010-01-28 12:00:00	IWM	ETF	60.5601	60.81	60.4	60.8	6734406.0
2010-01-28 13:00:00	IWM	ETF	60.8	61.2769	60.66	60.87	7835592.0
2010-01-28 14:00:00	IWM	ETF	60.87	61.01	60.57	60.905	6912907.0
2010-01-28 15:00:00	IWM	ETF	60.9	61.27	60.72	60.81	16307852.0
2010-01-28 16:00:00	IWM	ETF	60.8	61.8341	60.48	60.91	4177748.0
2010-01-28 17:00:00	IWM	ETF	60.96	60.97	60.79	60.85	103405.0
2010-01-28 18:00:00	IWM	ETF	60.8	60.8	60.61	60.64	5200.0
2010-01-28 19:00:00	IWM	ETF	60.66	60.67	60.52	60.52	5066.0
2010-01-28 07:00:00	DIA	ETF	102.65	102.9	102.65	102.9	800.0
2010-01-28 08:00:00	DIA	ETF	102.84	102.88	102.4	102.68	50768.0
2010-01-28 09:00:00	DIA	ETF	102.69	102.77	101.84	102.08	1666422.0
2010-01-28 10:00:00	DIA	ETF	102.07	102.07	101.22	101.35	2589305.0
2010-01-28 11:00:00	DIA	ETF	101.35	101.38	100.51	100.9	2661937.0
2010-01-28 12:00:00	DIA	ETF	100.89	101.08	100.69	101.08	1037441.0

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

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