PREVIEW / stock_1hour / 2008-09-25

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-09-25.parquet
  size:    819 KB
  rows:    40,497
  symbols: 3,343

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-09-25 05:00:00	AAPL	Stock	4.6425	4.6425	4.6425	4.6425	28000.0
2008-09-25 06:00:00	AAPL	Stock	4.6429	4.6429	4.6071	4.6071	14000.0
2008-09-25 07:00:00	AAPL	Stock	4.6082	4.6339	4.5489	4.5661	599284.0
2008-09-25 08:00:00	AAPL	Stock	4.5711	4.6332	4.5696	4.6229	6340012.0
2008-09-25 09:00:00	AAPL	Stock	4.6246	4.6661	4.59	4.6268	122293052.0
2008-09-25 10:00:00	AAPL	Stock	4.625	4.7107	4.6125	4.6886	186739168.0
2008-09-25 11:00:00	AAPL	Stock	4.6886	4.7354	4.6811	4.7175	95778704.0
2008-09-25 12:00:00	AAPL	Stock	4.7175	4.7743	4.7	4.7625	89235048.0
2008-09-25 13:00:00	AAPL	Stock	4.7623	4.8139	4.7454	4.7765	129169488.0
2008-09-25 14:00:00	AAPL	Stock	4.7768	4.7775	4.7036	4.7311	137535608.0
2008-09-25 15:00:00	AAPL	Stock	4.7318	4.7657	4.6796	4.7121	184144660.0
2008-09-25 16:00:00	AAPL	Stock	4.7118	4.7414	4.4979	4.5518	40827528.0
2008-09-25 17:00:00	AAPL	Stock	4.5546	4.7118	4.5268	4.5357	4336164.0
2008-09-25 18:00:00	AAPL	Stock	4.5357	4.5696	4.5357	4.5536	1300068.0
2008-09-25 19:00:00	AAPL	Stock	4.5536	4.5586	4.5179	4.5289	912912.0
2008-09-25 07:00:00	MSFT	Stock	25.8	25.8	25.8	25.8	1580.0
2008-09-25 08:00:00	MSFT	Stock	25.79	25.94	25.75	25.75	155723.0
2008-09-25 09:00:00	MSFT	Stock	25.75	26.35	25.54	26.27	9882506.0
2008-09-25 10:00:00	MSFT	Stock	26.27	26.67	26.18	26.362	17360815.0
2008-09-25 11:00:00	MSFT	Stock	26.37	26.67	26.34	26.55	8267132.0
2008-09-25 12:00:00	MSFT	Stock	26.552	26.69	26.5	26.61	9132578.0
2008-09-25 13:00:00	MSFT	Stock	26.6	26.82	26.59	26.7	12602667.0
2008-09-25 14:00:00	MSFT	Stock	26.7	26.75	26.48	26.62	13788434.0
2008-09-25 15:00:00	MSFT	Stock	26.62	26.88	26.51	26.65	19114165.0
2008-09-25 16:00:00	MSFT	Stock	26.65	26.88	26.4	26.48	3820227.0
2008-09-25 17:00:00	MSFT	Stock	26.41	26.623	26.33	26.35	19814.0
2008-09-25 18:00:00	MSFT	Stock	26.33	26.44	26.31	26.35	5459.0
2008-09-25 19:00:00	MSFT	Stock	26.34	26.35	26.2	26.3	36127.0
2008-09-25 07:00:00	NVDA	Stock	0.2825	0.2825	0.2812	0.282	12000.0
2008-09-25 08:00:00	NVDA	Stock	0.2812	0.2842	0.2812	0.2842	167080.0
2008-09-25 09:00:00	NVDA	Stock	0.2828	0.2855	0.2765	0.2825	70339880.0
2008-09-25 10:00:00	NVDA	Stock	0.2825	0.2848	0.2812	0.2825	94950960.0
2008-09-25 11:00:00	NVDA	Stock	0.2828	0.2882	0.2825	0.2872	80939880.0
2008-09-25 12:00:00	NVDA	Stock	0.287	0.291	0.2852	0.2905	59053320.0
2008-09-25 13:00:00	NVDA	Stock	0.2908	0.2935	0.2885	0.2905	77682960.0
2008-09-25 14:00:00	NVDA	Stock	0.2905	0.2905	0.2848	0.287	77028240.0
2008-09-25 15:00:00	NVDA	Stock	0.287	0.29	0.2842	0.2868	106502000.0
2008-09-25 16:00:00	NVDA	Stock	0.2868	0.2882	0.2818	0.284	10836360.0
2008-09-25 17:00:00	NVDA	Stock	0.284	0.2868	0.284	0.2868	109360.0
2008-09-25 18:00:00	NVDA	Stock	0.285	0.285	0.285	0.285	5400.0
2008-09-25 19:00:00	NVDA	Stock	0.284	0.284	0.2832	0.2832	21080.0
2008-09-25 08:00:00	AMZN	Stock	3.525	3.5795	3.525	3.5625	172000.0
2008-09-25 09:00:00	AMZN	Stock	3.555	3.572	3.5005	3.537	14450740.0
2008-09-25 10:00:00	AMZN	Stock	3.537	3.6	3.5255	3.571	28838260.0
2008-09-25 11:00:00	AMZN	Stock	3.5705	3.595	3.5575	3.5755	12439040.0
2008-09-25 12:00:00	AMZN	Stock	3.575	3.6055	3.571	3.5955	12609380.0
2008-09-25 13:00:00	AMZN	Stock	3.5955	3.632	3.5725	3.624	17392880.0
2008-09-25 14:00:00	AMZN	Stock	3.6255	3.6275	3.559	3.594	10480860.0
2008-09-25 15:00:00	AMZN	Stock	3.593	3.6375	3.5815	3.604	19416260.0
2008-09-25 16:00:00	AMZN	Stock	3.604	3.604	3.523	3.55	1339160.0

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

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