PREVIEW / stock_1hour / 2009-08-27

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-08-27.parquet
  size:    848 KB
  rows:    41,072
  symbols: 3,356

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
2009-08-27 06:00:00	AAPL	Stock	5.9993	5.9993	5.9993	5.9993	2800.0
2009-08-27 07:00:00	AAPL	Stock	5.9961	6.0268	5.9929	6.0036	137928.0
2009-08-27 08:00:00	AAPL	Stock	6.005	6.0411	6.0	6.0371	1944852.0
2009-08-27 09:00:00	AAPL	Stock	6.0375	6.0389	5.9268	5.9289	71014020.0
2009-08-27 10:00:00	AAPL	Stock	5.9282	5.9282	5.8868	5.9057	76152636.0
2009-08-27 11:00:00	AAPL	Stock	5.9054	5.9404	5.8971	5.9375	41215804.0
2009-08-27 12:00:00	AAPL	Stock	5.9368	5.9582	5.9325	5.9542	30693852.0
2009-08-27 13:00:00	AAPL	Stock	5.9539	6.0264	5.9532	6.0189	66579828.0
2009-08-27 14:00:00	AAPL	Stock	6.0189	6.0532	6.0189	6.0268	69662572.0
2009-08-27 15:00:00	AAPL	Stock	6.0268	6.0561	6.0157	6.0514	75012812.0
2009-08-27 16:00:00	AAPL	Stock	6.0514	6.0593	5.9777	6.055	7363048.0
2009-08-27 17:00:00	AAPL	Stock	6.055	6.0779	6.0514	6.0779	1019480.0
2009-08-27 18:00:00	AAPL	Stock	6.0779	6.0836	6.075	6.0768	658756.0
2009-08-27 19:00:00	AAPL	Stock	6.0768	6.0814	6.0718	6.0807	195300.0
2009-08-27 08:00:00	MSFT	Stock	24.46	24.47	24.43	24.43	4313.0
2009-08-27 09:00:00	MSFT	Stock	24.46	24.58	24.35	24.43	4314153.0
2009-08-27 10:00:00	MSFT	Stock	24.43	24.43	24.3	24.3	5762762.0
2009-08-27 11:00:00	MSFT	Stock	24.3	24.39	24.3	24.39	3498639.0
2009-08-27 12:00:00	MSFT	Stock	24.38	24.59	24.38	24.58	5609093.0
2009-08-27 13:00:00	MSFT	Stock	24.59	24.72	24.56	24.71	6181479.0
2009-08-27 14:00:00	MSFT	Stock	24.71	24.78	24.67	24.73	7563599.0
2009-08-27 15:00:00	MSFT	Stock	24.74	24.78	24.62	24.7	8899257.0
2009-08-27 16:00:00	MSFT	Stock	24.7	24.75	24.569	24.67	1569371.0
2009-08-27 17:00:00	MSFT	Stock	24.67	24.79	24.67	24.76	93840.0
2009-08-27 18:00:00	MSFT	Stock	24.69	24.79	24.69	24.79	27768.0
2009-08-27 19:00:00	MSFT	Stock	24.75	24.79	24.75	24.78	5395.0
2009-08-27 20:00:00	MSFT	Stock	24.32	24.32	24.32	24.32	4400.0
2009-08-27 08:00:00	NVDA	Stock	0.3425	0.3438	0.3425	0.3425	98000.0
2009-08-27 09:00:00	NVDA	Stock	0.3462	0.3488	0.3433	0.3458	82994560.0
2009-08-27 10:00:00	NVDA	Stock	0.3458	0.3462	0.3433	0.3438	110692280.0
2009-08-27 11:00:00	NVDA	Stock	0.3438	0.3478	0.3438	0.3475	68627760.0
2009-08-27 12:00:00	NVDA	Stock	0.3475	0.3498	0.3475	0.3488	63021720.0
2009-08-27 13:00:00	NVDA	Stock	0.349	0.35	0.3462	0.3493	46973800.0
2009-08-27 14:00:00	NVDA	Stock	0.3495	0.3515	0.349	0.3505	80904920.0
2009-08-27 15:00:00	NVDA	Stock	0.3505	0.3518	0.349	0.3502	76598880.0
2009-08-27 16:00:00	NVDA	Stock	0.3502	0.3515	0.3475	0.3502	1617880.0
2009-08-27 17:00:00	NVDA	Stock	0.3505	0.3525	0.3505	0.3525	108000.0
2009-08-27 18:00:00	NVDA	Stock	0.3525	0.353	0.3525	0.3525	72000.0
2009-08-27 19:00:00	NVDA	Stock	0.3513	0.3513	0.3513	0.3513	8080.0
2009-08-27 08:00:00	AMZN	Stock	4.2	4.2	4.2	4.2	6000.0
2009-08-27 09:00:00	AMZN	Stock	4.2055	4.2055	4.1705	4.1706	10135520.0
2009-08-27 10:00:00	AMZN	Stock	4.1705	4.1915	4.157	4.173	10406780.0
2009-08-27 11:00:00	AMZN	Stock	4.1735	4.1885	4.16	4.188	6930920.0
2009-08-27 12:00:00	AMZN	Stock	4.1875	4.21	4.1845	4.1965	7035200.0
2009-08-27 13:00:00	AMZN	Stock	4.197	4.228	4.183	4.226	7696740.0
2009-08-27 14:00:00	AMZN	Stock	4.226	4.2425	4.198	4.2015	14309280.0
2009-08-27 15:00:00	AMZN	Stock	4.2005	4.216	4.1885	4.2135	21096760.0
2009-08-27 16:00:00	AMZN	Stock	4.2135	4.2156	4.1971	4.2075	1830680.0
2009-08-27 18:00:00	AMZN	Stock	4.211	4.2225	4.211	4.2115	20000.0
2009-08-27 19:00:00	AMZN	Stock	4.224	4.224	4.224	4.224	2000.0

> showing 50 of 41,072 rows — these rows as CSV

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