PREVIEW / stock_1hour / 2008-01-25

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-01-25.parquet
  size:    808 KB
  rows:    40,505
  symbols: 3,270

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
2008-01-25 04:00:00	AAPL	Stock	4.9461	4.9464	4.9461	4.9464	11200.0
2008-01-25 05:00:00	AAPL	Stock	4.9718	4.9839	4.9718	4.9839	8540.0
2008-01-25 06:00:00	AAPL	Stock	4.9732	4.9732	4.9464	4.9593	105672.0
2008-01-25 07:00:00	AAPL	Stock	4.9471	4.9607	4.9196	4.9214	659400.0
2008-01-25 08:00:00	AAPL	Stock	4.9271	4.9821	4.8957	4.9557	11704476.0
2008-01-25 09:00:00	AAPL	Stock	4.9571	4.9675	4.8525	4.905	248921176.0
2008-01-25 10:00:00	AAPL	Stock	4.9054	4.9054	4.7564	4.7657	322424508.0
2008-01-25 11:00:00	AAPL	Stock	4.7661	4.7946	4.7189	4.7925	218564780.0
2008-01-25 12:00:00	AAPL	Stock	4.7929	4.8011	4.7068	4.7096	134967560.0
2008-01-25 13:00:00	AAPL	Stock	4.7097	4.7246	4.6518	4.6729	179310264.0
2008-01-25 14:00:00	AAPL	Stock	4.6729	4.7179	4.65	4.6876	175392196.0
2008-01-25 15:00:00	AAPL	Stock	4.6868	4.7229	4.6289	4.6421	240140460.0
2008-01-25 16:00:00	AAPL	Stock	4.642	4.7687	4.6361	4.6411	22739584.0
2008-01-25 17:00:00	AAPL	Stock	4.6411	4.8429	4.6304	4.6357	2439108.0
2008-01-25 18:00:00	AAPL	Stock	4.6432	4.6439	4.6304	4.6393	1996540.0
2008-01-25 19:00:00	AAPL	Stock	4.6386	4.6425	4.6321	4.6321	382312.0
2008-01-25 07:00:00	MSFT	Stock	34.75	34.95	34.75	34.95	44422.0
2008-01-25 08:00:00	MSFT	Stock	34.9	35.24	33.25	34.8	1826590.0
2008-01-25 09:00:00	MSFT	Stock	34.84	35.0	34.14	34.19	34960601.0
2008-01-25 10:00:00	MSFT	Stock	34.199	34.25	33.56	33.61	43026566.0
2008-01-25 11:00:00	MSFT	Stock	33.61	33.65	33.36	33.6	26048633.0
2008-01-25 12:00:00	MSFT	Stock	33.59	33.68	33.06	33.2	19206531.0
2008-01-25 13:00:00	MSFT	Stock	33.198	33.4	33.04	33.36	17663576.0
2008-01-25 14:00:00	MSFT	Stock	33.36	33.46	33.1	33.17	17939252.0
2008-01-25 15:00:00	MSFT	Stock	33.17	33.31	32.87	32.95	30617184.0
2008-01-25 16:00:00	MSFT	Stock	32.94	34.46	32.85	32.87	4959093.0
2008-01-25 17:00:00	MSFT	Stock	32.88	33.25	32.87	32.89	328327.0
2008-01-25 18:00:00	MSFT	Stock	32.9	32.94	32.88	32.89	471338.0
2008-01-25 19:00:00	MSFT	Stock	32.89	32.91	32.89	32.9	31543.0
2008-01-25 07:00:00	NVDA	Stock	0.6872	0.6872	0.66	0.6625	60000.0
2008-01-25 08:00:00	NVDA	Stock	0.667	0.675	0.667	0.6748	704000.0
2008-01-25 09:00:00	NVDA	Stock	0.675	0.6865	0.6525	0.6597	122390360.0
2008-01-25 10:00:00	NVDA	Stock	0.6595	0.661	0.6428	0.6452	130542200.0
2008-01-25 11:00:00	NVDA	Stock	0.646	0.6473	0.6395	0.645	98862680.0
2008-01-25 12:00:00	NVDA	Stock	0.645	0.6473	0.632	0.6353	55102880.0
2008-01-25 13:00:00	NVDA	Stock	0.6353	0.6412	0.6208	0.621	81920600.0
2008-01-25 14:00:00	NVDA	Stock	0.6213	0.6335	0.6208	0.63	59379240.0
2008-01-25 15:00:00	NVDA	Stock	0.63	0.6353	0.6233	0.624	116639040.0
2008-01-25 16:00:00	NVDA	Stock	0.6242	0.6448	0.62	0.6225	8601600.0
2008-01-25 17:00:00	NVDA	Stock	0.6468	0.6468	0.62	0.62	917640.0
2008-01-25 18:00:00	NVDA	Stock	0.6238	0.6238	0.6238	0.6238	1236840.0
2008-01-25 19:00:00	NVDA	Stock	0.626	0.626	0.626	0.626	4000.0
2008-01-25 04:00:00	AMZN	Stock	3.9005	3.9005	3.9005	3.9005	8000.0
2008-01-25 07:00:00	AMZN	Stock	3.9005	3.9005	3.9005	3.9005	4000.0
2008-01-25 08:00:00	AMZN	Stock	3.9235	3.945	3.9235	3.9385	76000.0
2008-01-25 09:00:00	AMZN	Stock	3.9355	4.0715	3.925	3.975	40790280.0
2008-01-25 10:00:00	AMZN	Stock	3.975	3.984	3.888	3.8945	33931120.0
2008-01-25 11:00:00	AMZN	Stock	3.894	3.9635	3.8625	3.9355	25766480.0
2008-01-25 12:00:00	AMZN	Stock	3.9355	3.955	3.9065	3.9165	13884160.0
2008-01-25 13:00:00	AMZN	Stock	3.918	3.9255	3.858	3.8675	20013300.0

> showing 50 of 40,505 rows — these rows as CSV

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