PREVIEW / stock_1hour / 2008-06-30

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-06-30.parquet
  size:    856 KB
  rows:    40,906
  symbols: 3,350

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-06-30 04:00:00	AAPL	Stock	6.0664	6.0664	6.0664	6.0664	2800.0
2008-06-30 05:00:00	AAPL	Stock	6.0239	6.0239	6.0239	6.0239	8400.0
2008-06-30 06:00:00	AAPL	Stock	6.0211	6.0364	6.0211	6.0364	119672.0
2008-06-30 07:00:00	AAPL	Stock	6.0318	6.0568	6.0211	6.0211	114408.0
2008-06-30 08:00:00	AAPL	Stock	6.0357	6.1071	6.0232	6.1054	2297540.0
2008-06-30 09:00:00	AAPL	Stock	6.1032	6.1429	6.0404	6.0421	36421392.0
2008-06-30 10:00:00	AAPL	Stock	6.0429	6.095	6.0168	6.0582	109769184.0
2008-06-30 11:00:00	AAPL	Stock	6.0582	6.0771	5.9911	6.0136	89024180.0
2008-06-30 12:00:00	AAPL	Stock	6.0129	6.0618	6.0004	6.0064	61721016.0
2008-06-30 13:00:00	AAPL	Stock	6.0064	6.03	5.9507	5.9625	79701468.0
2008-06-30 14:00:00	AAPL	Stock	5.9629	6.0104	5.96	5.9954	79664452.0
2008-06-30 15:00:00	AAPL	Stock	5.9961	6.0425	5.98	5.98	107786616.0
2008-06-30 16:00:00	AAPL	Stock	5.98	6.0363	5.9786	5.9918	21073444.0
2008-06-30 17:00:00	AAPL	Stock	5.9964	6.0069	5.98	5.9957	495208.0
2008-06-30 18:00:00	AAPL	Stock	5.995	5.9982	5.9929	5.9964	100800.0
2008-06-30 19:00:00	AAPL	Stock	5.9961	6.0	5.995	5.9964	60172.0
2008-06-30 06:00:00	MSFT	Stock	27.41	27.41	27.41	27.41	1100.0
2008-06-30 08:00:00	MSFT	Stock	27.55	27.8	27.55	27.66	23477.0
2008-06-30 09:00:00	MSFT	Stock	27.66	27.89	27.62	27.852	1422530.0
2008-06-30 10:00:00	MSFT	Stock	27.85	27.88	27.712	27.88	6417455.0
2008-06-30 11:00:00	MSFT	Stock	27.88	27.98	27.8	27.882	6769150.0
2008-06-30 12:00:00	MSFT	Stock	27.89	27.9	27.75	27.79	5120265.0
2008-06-30 13:00:00	MSFT	Stock	27.79	27.83	27.73	27.79	6121243.0
2008-06-30 14:00:00	MSFT	Stock	27.77	27.81	27.68	27.7	5702631.0
2008-06-30 15:00:00	MSFT	Stock	27.71	27.84	27.49	27.5	13831291.0
2008-06-30 16:00:00	MSFT	Stock	27.52	27.782	27.5	27.51	6180865.0
2008-06-30 17:00:00	MSFT	Stock	27.55	27.738	27.488	27.57	62522.0
2008-06-30 18:00:00	MSFT	Stock	27.59	27.59	27.55	27.59	3500.0
2008-06-30 19:00:00	MSFT	Stock	27.59	27.59	27.58	27.59	3400.0
2008-06-30 08:00:00	NVDA	Stock	0.482	0.482	0.4745	0.4782	176000.0
2008-06-30 09:00:00	NVDA	Stock	0.4772	0.4806	0.4648	0.4662	49849480.0
2008-06-30 10:00:00	NVDA	Stock	0.4662	0.4723	0.4652	0.471	106357000.0
2008-06-30 11:00:00	NVDA	Stock	0.471	0.4748	0.4685	0.4718	66884040.0
2008-06-30 12:00:00	NVDA	Stock	0.4718	0.4725	0.4685	0.4695	50193080.0
2008-06-30 13:00:00	NVDA	Stock	0.4692	0.4705	0.4652	0.467	59639240.0
2008-06-30 14:00:00	NVDA	Stock	0.4668	0.47	0.4662	0.4688	85621280.0
2008-06-30 15:00:00	NVDA	Stock	0.4688	0.471	0.4658	0.4665	151235240.0
2008-06-30 16:00:00	NVDA	Stock	0.467	0.4696	0.4662	0.468	42348800.0
2008-06-30 17:00:00	NVDA	Stock	0.4675	0.4675	0.4652	0.4652	33240.0
2008-06-30 18:00:00	NVDA	Stock	0.467	0.4685	0.467	0.4685	68000.0
2008-06-30 19:00:00	NVDA	Stock	0.4685	0.4685	0.4685	0.4685	186000.0
2008-06-30 08:00:00	AMZN	Stock	3.706	3.7525	3.706	3.7525	27160.0
2008-06-30 09:00:00	AMZN	Stock	3.7525	3.7525	3.6875	3.7115	9314380.0
2008-06-30 10:00:00	AMZN	Stock	3.711	3.761	3.704	3.7605	22327700.0
2008-06-30 11:00:00	AMZN	Stock	3.7615	3.806	3.752	3.7525	21271000.0
2008-06-30 12:00:00	AMZN	Stock	3.7535	3.77	3.732	3.7355	9629760.0
2008-06-30 13:00:00	AMZN	Stock	3.7355	3.7365	3.6875	3.7	11797880.0
2008-06-30 14:00:00	AMZN	Stock	3.7	3.7115	3.6715	3.6845	16710360.0
2008-06-30 15:00:00	AMZN	Stock	3.685	3.7055	3.6605	3.663	31530980.0
2008-06-30 16:00:00	AMZN	Stock	3.6645	3.7442	3.6635	3.6665	6756460.0

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

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