PREVIEW / stock_1hour / 2009-06-25

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-06-25.parquet
  size:    834 KB
  rows:    40,881
  symbols: 3,354

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-06-25 05:00:00	AAPL	Stock	4.8868	4.8868	4.8868	4.8868	14000.0
2009-06-25 06:00:00	AAPL	Stock	4.8943	4.9025	4.8943	4.9025	28000.0
2009-06-25 07:00:00	AAPL	Stock	4.8857	4.9054	4.8857	4.8993	123200.0
2009-06-25 08:00:00	AAPL	Stock	4.8936	4.8979	4.8339	4.8432	1722560.0
2009-06-25 09:00:00	AAPL	Stock	4.8404	4.9425	4.8289	4.9336	92774444.0
2009-06-25 10:00:00	AAPL	Stock	4.9336	4.9768	4.9286	4.9618	112365848.0
2009-06-25 11:00:00	AAPL	Stock	4.9621	4.9896	4.9568	4.9811	67897844.0
2009-06-25 12:00:00	AAPL	Stock	4.9814	4.9893	4.9696	4.9793	45962896.0
2009-06-25 13:00:00	AAPL	Stock	4.9789	5.0	4.9754	4.9879	46879532.0
2009-06-25 14:00:00	AAPL	Stock	4.9879	4.9907	4.9714	4.975	65401140.0
2009-06-25 15:00:00	AAPL	Stock	4.975	5.0071	4.9568	4.9979	124189996.0
2009-06-25 16:00:00	AAPL	Stock	5.0025	5.0046	4.9594	4.9936	19722080.0
2009-06-25 17:00:00	AAPL	Stock	4.9996	5.0071	4.9982	4.9982	253736.0
2009-06-25 18:00:00	AAPL	Stock	4.9982	5.0	4.995	4.9993	1336664.0
2009-06-25 19:00:00	AAPL	Stock	4.9986	4.9993	4.995	4.9964	98252.0
2009-06-25 08:00:00	MSFT	Stock	23.55	23.69	23.38	23.38	20496.0
2009-06-25 09:00:00	MSFT	Stock	23.42	23.55	23.2	23.49	7258058.0
2009-06-25 10:00:00	MSFT	Stock	23.49	23.73	23.49	23.595	8181498.0
2009-06-25 11:00:00	MSFT	Stock	23.6	23.87	23.58	23.81	7053899.0
2009-06-25 12:00:00	MSFT	Stock	23.8	23.84	23.675	23.69	4972806.0
2009-06-25 13:00:00	MSFT	Stock	23.69	23.88	23.67	23.849	5887500.0
2009-06-25 14:00:00	MSFT	Stock	23.84	23.86	23.65	23.69	7574733.0
2009-06-25 15:00:00	MSFT	Stock	23.69	23.92	23.62	23.8	12585110.0
2009-06-25 16:00:00	MSFT	Stock	23.8	23.86	23.686	23.77	2959205.0
2009-06-25 17:00:00	MSFT	Stock	23.76	23.78	23.76	23.78	600.0
2009-06-25 18:00:00	MSFT	Stock	23.82	23.83	23.75	23.76	4875.0
2009-06-25 19:00:00	MSFT	Stock	23.84	23.84	23.77	23.77	200.0
2009-06-25 09:00:00	NVDA	Stock	0.2708	0.2808	0.266	0.2795	91845920.0
2009-06-25 10:00:00	NVDA	Stock	0.2795	0.2815	0.2788	0.28	154946600.0
2009-06-25 11:00:00	NVDA	Stock	0.28	0.2855	0.28	0.2848	135015280.0
2009-06-25 12:00:00	NVDA	Stock	0.2848	0.285	0.2818	0.2822	87968400.0
2009-06-25 13:00:00	NVDA	Stock	0.2825	0.2855	0.2822	0.284	78477600.0
2009-06-25 14:00:00	NVDA	Stock	0.2842	0.2848	0.2822	0.2832	164017320.0
2009-06-25 15:00:00	NVDA	Stock	0.2832	0.286	0.283	0.2855	117285760.0
2009-06-25 16:00:00	NVDA	Stock	0.2858	0.286	0.282	0.2855	32445080.0
2009-06-25 17:00:00	NVDA	Stock	0.2862	0.2862	0.2862	0.2862	60000.0
2009-06-25 18:00:00	NVDA	Stock	0.2862	0.2862	0.2862	0.2862	12000.0
2009-06-25 19:00:00	NVDA	Stock	0.2865	0.2868	0.2865	0.2868	316000.0
2009-06-25 09:00:00	AMZN	Stock	3.951	4.05	3.951	4.0395	24263340.0
2009-06-25 10:00:00	AMZN	Stock	4.0395	4.084	4.0355	4.0549	36418220.0
2009-06-25 11:00:00	AMZN	Stock	4.0545	4.084	4.041	4.083	13058320.0
2009-06-25 12:00:00	AMZN	Stock	4.0835	4.0885	4.04	4.0455	10294740.0
2009-06-25 13:00:00	AMZN	Stock	4.044	4.079	4.042	4.056	9552820.0
2009-06-25 14:00:00	AMZN	Stock	4.056	4.079	4.0425	4.0675	15052120.0
2009-06-25 15:00:00	AMZN	Stock	4.069	4.1115	4.0605	4.11	30718160.0
2009-06-25 16:00:00	AMZN	Stock	4.108	4.1115	4.0589	4.111	2345760.0
2009-06-25 17:00:00	AMZN	Stock	4.1085	4.1105	4.108	4.108	11300.0
2009-06-25 18:00:00	AMZN	Stock	4.108	4.108	4.108	4.108	9000.0
2009-06-25 19:00:00	AMZN	Stock	4.11	4.11	4.1075	4.1075	27800.0
2009-06-25 08:00:00	TLT	Stock	92.63	93.29	92.63	93.1	19180.0

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

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