PREVIEW / stock_1hour / 2007-01-26

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-01-26.parquet
  size:    634 KB
  rows:    30,279
  symbols: 2,496

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
2007-01-26 07:00:00	AAPL	Stock	3.0879	3.0989	3.0879	3.0989	78400.0
2007-01-26 08:00:00	AAPL	Stock	3.1004	3.1111	3.0921	3.1093	3786664.0
2007-01-26 09:00:00	AAPL	Stock	3.1093	3.1204	3.0629	3.0679	145881820.0
2007-01-26 10:00:00	AAPL	Stock	3.0671	3.1093	3.0454	3.0735	245008148.0
2007-01-26 11:00:00	AAPL	Stock	3.0732	3.0764	3.0536	3.0604	112747600.0
2007-01-26 12:00:00	AAPL	Stock	3.06	3.0714	3.0486	3.0518	100437372.0
2007-01-26 13:00:00	AAPL	Stock	3.0518	3.0568	3.0354	3.0529	134355536.0
2007-01-26 14:00:00	AAPL	Stock	3.0529	3.0621	3.0393	3.0611	100725184.0
2007-01-26 15:00:00	AAPL	Stock	3.0614	3.0743	3.0493	3.0493	132028736.0
2007-01-26 16:00:00	AAPL	Stock	3.0507	3.0514	3.0446	3.0479	2171344.0
2007-01-26 17:00:00	AAPL	Stock	3.0479	3.0493	3.0457	3.0461	497448.0
2007-01-26 18:00:00	AAPL	Stock	3.0454	3.0475	3.045	3.0471	125916.0
2007-01-26 19:00:00	AAPL	Stock	3.0464	3.0482	3.0464	3.0482	145740.0
2007-01-26 05:00:00	MSFT	Stock	31.0	31.0	31.0	31.0	800.0
2007-01-26 06:00:00	MSFT	Stock	31.03	31.03	31.03	31.03	100.0
2007-01-26 07:00:00	MSFT	Stock	31.06	31.06	30.98	31.0	42300.0
2007-01-26 08:00:00	MSFT	Stock	31.04	31.2	30.78	31.02	463906.0
2007-01-26 09:00:00	MSFT	Stock	31.01	31.23	30.69	30.84	17692203.0
2007-01-26 10:00:00	MSFT	Stock	30.84	31.19	30.67	30.82	19921938.0
2007-01-26 11:00:00	MSFT	Stock	30.82	31.16	30.79	31.072	17132257.0
2007-01-26 12:00:00	MSFT	Stock	31.07	31.16	30.91	30.92	7579578.0
2007-01-26 13:00:00	MSFT	Stock	30.922	30.95	30.72	30.9	8856180.0
2007-01-26 14:00:00	MSFT	Stock	30.9	31.22	30.81	30.88	7287996.0
2007-01-26 15:00:00	MSFT	Stock	30.88	30.91	30.6	30.6	13834480.0
2007-01-26 16:00:00	MSFT	Stock	30.62	31.02	30.58	30.64	1554041.0
2007-01-26 17:00:00	MSFT	Stock	30.63	30.65	30.62	30.64	12869.0
2007-01-26 18:00:00	MSFT	Stock	30.63	30.64	30.61	30.64	14746.0
2007-01-26 19:00:00	MSFT	Stock	30.63	30.64	30.62	30.62	3710.0
2007-01-26 08:00:00	NVDA	Stock	0.533	0.5337	0.533	0.5333	240000.0
2007-01-26 09:00:00	NVDA	Stock	0.5337	0.5358	0.515	0.5232	95602260.0
2007-01-26 10:00:00	NVDA	Stock	0.5232	0.536	0.5172	0.534	136292460.0
2007-01-26 11:00:00	NVDA	Stock	0.534	0.5363	0.5308	0.5347	95300520.0
2007-01-26 12:00:00	NVDA	Stock	0.5348	0.5385	0.5323	0.5377	82577940.0
2007-01-26 13:00:00	NVDA	Stock	0.5377	0.5383	0.5343	0.5372	69795780.0
2007-01-26 14:00:00	NVDA	Stock	0.537	0.5377	0.5307	0.5332	102160620.0
2007-01-26 15:00:00	NVDA	Stock	0.533	0.5343	0.5225	0.524	183276840.0
2007-01-26 16:00:00	NVDA	Stock	0.524	0.5283	0.5218	0.5227	7106400.0
2007-01-26 17:00:00	NVDA	Stock	0.5242	0.5243	0.5242	0.5243	45000.0
2007-01-26 19:00:00	NVDA	Stock	0.5233	0.5233	0.5233	0.5233	90000.0
2007-01-26 08:00:00	AMZN	Stock	1.821	1.821	1.821	1.821	5000.0
2007-01-26 09:00:00	AMZN	Stock	1.8585	1.8645	1.829	1.833	8735800.0
2007-01-26 10:00:00	AMZN	Stock	1.833	1.85	1.815	1.84	18276340.0
2007-01-26 11:00:00	AMZN	Stock	1.84	1.85	1.824	1.8335	11804900.0
2007-01-26 12:00:00	AMZN	Stock	1.841	1.8525	1.832	1.839	8124000.0
2007-01-26 13:00:00	AMZN	Stock	1.8395	1.8428	1.8295	1.8375	7895920.0
2007-01-26 14:00:00	AMZN	Stock	1.838	1.8445	1.834	1.84	10292660.0
2007-01-26 15:00:00	AMZN	Stock	1.84	1.849	1.8395	1.841	14990680.0
2007-01-26 16:00:00	AMZN	Stock	1.8415	1.8415	1.8375	1.8395	190920.0
2007-01-26 19:00:00	AMZN	Stock	1.8395	1.8395	1.8395	1.8395	4000.0
2007-01-26 09:00:00	CL	Stock	33.025	33.075	32.815	32.915	186600.0

> showing 50 of 30,279 rows — these rows as CSV

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