PREVIEW / stock_1hour / 2010-02-25

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-02-25.parquet
  size:    881 KB
  rows:    42,282
  symbols: 3,439

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-25 04:00:00	AAPL	Stock	7.1254	7.1361	7.1254	7.1361	5600.0
2010-02-25 06:00:00	AAPL	Stock	7.1339	7.1339	7.1339	7.1339	5600.0
2010-02-25 07:00:00	AAPL	Stock	7.1346	7.1364	7.1246	7.125	60368.0
2010-02-25 08:00:00	AAPL	Stock	7.125	7.1364	7.0996	7.1036	2449580.0
2010-02-25 09:00:00	AAPL	Stock	7.105	7.105	7.0318	7.0611	84165844.0
2010-02-25 10:00:00	AAPL	Stock	7.0614	7.0893	7.0471	7.0628	83639388.0
2010-02-25 11:00:00	AAPL	Stock	7.0614	7.0804	7.0468	7.0521	45972584.0
2010-02-25 12:00:00	AAPL	Stock	7.0514	7.0807	7.0479	7.07	35271040.0
2010-02-25 13:00:00	AAPL	Stock	7.0714	7.125	7.0571	7.125	51077096.0
2010-02-25 14:00:00	AAPL	Stock	7.125	7.1743	7.125	7.1614	184288552.0
2010-02-25 15:00:00	AAPL	Stock	7.1614	7.245	7.1614	7.2143	168922936.0
2010-02-25 16:00:00	AAPL	Stock	7.2161	7.2242	7.0645	7.2107	5205928.0
2010-02-25 17:00:00	AAPL	Stock	7.2118	7.2129	7.2007	7.2007	369796.0
2010-02-25 18:00:00	AAPL	Stock	7.2014	7.2143	7.2014	7.2061	196840.0
2010-02-25 19:00:00	AAPL	Stock	7.2061	7.2143	7.2046	7.2121	217700.0
2010-02-25 07:00:00	MSFT	Stock	28.52	28.52	28.51	28.51	2000.0
2010-02-25 08:00:00	MSFT	Stock	28.52	28.52	28.4	28.41	39333.0
2010-02-25 09:00:00	MSFT	Stock	28.4	28.41	28.02	28.085	5574031.0
2010-02-25 10:00:00	MSFT	Stock	28.088	28.22	28.03	28.15	8525339.0
2010-02-25 11:00:00	MSFT	Stock	28.141	28.17	28.09	28.15	5249725.0
2010-02-25 12:00:00	MSFT	Stock	28.15	28.33	28.14	28.275	6469450.0
2010-02-25 13:00:00	MSFT	Stock	28.28	28.52	28.18	28.505	4550055.0
2010-02-25 14:00:00	MSFT	Stock	28.52	28.6	28.42	28.5	5920658.0
2010-02-25 15:00:00	MSFT	Stock	28.5	28.65	28.45	28.6	8266038.0
2010-02-25 16:00:00	MSFT	Stock	28.61	28.61	28.097	28.56	1846322.0
2010-02-25 17:00:00	MSFT	Stock	28.56	28.63	28.52	28.63	700200.0
2010-02-25 18:00:00	MSFT	Stock	28.52	28.58	28.52	28.58	400.0
2010-02-25 19:00:00	MSFT	Stock	28.58	28.65	28.58	28.6	14435.0
2010-02-25 20:00:00	MSFT	Stock	28.2	28.2	28.2	28.2	26800.0
2010-02-25 09:00:00	NVDA	Stock	0.4068	0.4072	0.394	0.4018	125628360.0
2010-02-25 10:00:00	NVDA	Stock	0.4015	0.4049	0.4	0.4012	80717160.0
2010-02-25 11:00:00	NVDA	Stock	0.401	0.4025	0.3988	0.399	63987800.0
2010-02-25 12:00:00	NVDA	Stock	0.3993	0.402	0.3988	0.402	41591400.0
2010-02-25 13:00:00	NVDA	Stock	0.4019	0.4075	0.4013	0.407	70208280.0
2010-02-25 14:00:00	NVDA	Stock	0.4072	0.4082	0.405	0.4072	62300000.0
2010-02-25 15:00:00	NVDA	Stock	0.4072	0.411	0.4068	0.41	126045040.0
2010-02-25 16:00:00	NVDA	Stock	0.4085	0.41	0.402	0.4088	916280.0
2010-02-25 18:00:00	NVDA	Stock	0.41	0.41	0.41	0.41	906240.0
2010-02-25 08:00:00	AMZN	Stock	5.9475	5.9505	5.91	5.9235	459240.0
2010-02-25 09:00:00	AMZN	Stock	5.923	5.9285	5.8275	5.8515	31347160.0
2010-02-25 10:00:00	AMZN	Stock	5.8505	5.861	5.7925	5.8255	45483120.0
2010-02-25 11:00:00	AMZN	Stock	5.8265	5.852	5.825	5.8355	22061000.0
2010-02-25 12:00:00	AMZN	Stock	5.835	5.8495	5.83	5.8315	14606880.0
2010-02-25 13:00:00	AMZN	Stock	5.831	5.8825	5.83	5.8795	19510960.0
2010-02-25 14:00:00	AMZN	Stock	5.88	5.894	5.85	5.872	20140400.0
2010-02-25 15:00:00	AMZN	Stock	5.8718	5.912	5.867	5.9095	34636740.0
2010-02-25 16:00:00	AMZN	Stock	5.9075	5.91	5.8154	5.91	490640.0
2010-02-25 17:00:00	AMZN	Stock	5.91	5.914	5.909	5.914	67000.0
2010-02-25 18:00:00	AMZN	Stock	5.91	5.925	5.903	5.91	212400.0
2010-02-25 19:00:00	AMZN	Stock	5.9145	5.915	5.9145	5.915	8600.0

> showing 50 of 42,282 rows — these rows as CSV

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