PREVIEW / stock_30min / 2008-06-30

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-06-30.parquet
  size:    1.3 MB
  rows:    70,300
  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:30: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.0221	6.0357	77168.0
2008-06-30 07:30:00	AAPL	Stock	6.0418	6.0418	6.0211	6.0211	37240.0
2008-06-30 08:00:00	AAPL	Stock	6.0357	6.085	6.0232	6.0786	1140748.0
2008-06-30 08:30:00	AAPL	Stock	6.0711	6.1071	6.0607	6.1054	1156792.0
2008-06-30 09:00:00	AAPL	Stock	6.1032	6.1032	6.0771	6.0807	933324.0
2008-06-30 09:30:00	AAPL	Stock	6.0807	6.1429	6.0404	6.0421	35488068.0
2008-06-30 10:00:00	AAPL	Stock	6.0429	6.095	6.0282	6.0846	53791080.0
2008-06-30 10:30:00	AAPL	Stock	6.0843	6.0918	6.0168	6.0582	55978104.0
2008-06-30 11:00:00	AAPL	Stock	6.0582	6.0771	5.9943	6.06	44694244.0
2008-06-30 11:30:00	AAPL	Stock	6.06	6.0621	5.9911	6.0136	44329936.0
2008-06-30 12:00:00	AAPL	Stock	6.0129	6.0593	6.0004	6.0593	33038936.0
2008-06-30 12:30:00	AAPL	Stock	6.06	6.0618	6.0032	6.0064	28682080.0
2008-06-30 13:00:00	AAPL	Stock	6.0064	6.03	5.9896	6.0082	32350500.0
2008-06-30 13:30:00	AAPL	Stock	6.0093	6.0121	5.9507	5.9625	47350968.0
2008-06-30 14:00:00	AAPL	Stock	5.9629	6.0104	5.96	6.0021	37112012.0
2008-06-30 14:30:00	AAPL	Stock	6.0025	6.0104	5.9732	5.9954	42552440.0
2008-06-30 15:00:00	AAPL	Stock	5.9961	6.0425	5.995	6.0186	45575012.0
2008-06-30 15:30:00	AAPL	Stock	6.0186	6.0314	5.98	5.98	62211604.0
2008-06-30 16:00:00	AAPL	Stock	5.98	6.0363	5.9786	6.0345	18694396.0
2008-06-30 16:30:00	AAPL	Stock	5.9946	5.9961	5.98	5.9918	2379048.0
2008-06-30 17:00:00	AAPL	Stock	5.9964	6.0069	5.98	5.9929	358960.0
2008-06-30 17:30:00	AAPL	Stock	5.9932	5.9961	5.9879	5.9957	136248.0
2008-06-30 18:00:00	AAPL	Stock	5.995	5.9964	5.9929	5.9964	32200.0
2008-06-30 18:30:00	AAPL	Stock	5.9964	5.9982	5.9961	5.9964	68600.0
2008-06-30 19:00:00	AAPL	Stock	5.9961	5.9961	5.995	5.995	9240.0
2008-06-30 19:30:00	AAPL	Stock	5.9982	6.0	5.9964	5.9964	50932.0
2008-06-30 06:30:00	MSFT	Stock	27.41	27.41	27.41	27.41	1100.0
2008-06-30 08:00:00	MSFT	Stock	27.55	27.7	27.55	27.7	2147.0
2008-06-30 08:30:00	MSFT	Stock	27.7	27.8	27.64	27.66	21330.0
2008-06-30 09:00:00	MSFT	Stock	27.66	27.72	27.62	27.65	12436.0
2008-06-30 09:30:00	MSFT	Stock	27.67	27.89	27.62	27.852	1410094.0
2008-06-30 10:00:00	MSFT	Stock	27.85	27.86	27.712	27.8	2671186.0
2008-06-30 10:30:00	MSFT	Stock	27.8	27.88	27.75	27.88	3746269.0
2008-06-30 11:00:00	MSFT	Stock	27.88	27.98	27.84	27.9	3690388.0
2008-06-30 11:30:00	MSFT	Stock	27.91	27.93	27.8	27.882	3078762.0
2008-06-30 12:00:00	MSFT	Stock	27.89	27.9	27.79	27.84	2665517.0
2008-06-30 12:30:00	MSFT	Stock	27.842	27.87	27.75	27.79	2454748.0
2008-06-30 13:00:00	MSFT	Stock	27.79	27.83	27.74	27.78	2604623.0
2008-06-30 13:30:00	MSFT	Stock	27.78	27.82	27.73	27.79	3516620.0
2008-06-30 14:00:00	MSFT	Stock	27.77	27.81	27.71	27.78	2608398.0
2008-06-30 14:30:00	MSFT	Stock	27.79	27.79	27.68	27.7	3094233.0
2008-06-30 15:00:00	MSFT	Stock	27.71	27.84	27.7	27.78	4838246.0
2008-06-30 15:30:00	MSFT	Stock	27.78	27.8	27.49	27.5	8993045.0
2008-06-30 16:00:00	MSFT	Stock	27.52	27.782	27.5	27.747	6012418.0
2008-06-30 16:30:00	MSFT	Stock	27.53	27.57	27.51	27.51	168447.0
2008-06-30 17:00:00	MSFT	Stock	27.55	27.738	27.55	27.738	57300.0
2008-06-30 17:30:00	MSFT	Stock	27.59	27.59	27.488	27.57	5222.0

> showing 50 of 70,300 rows — these rows as CSV

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