PREVIEW / stock_30min / 2006-06-27

all stock 30-min files

  file:    by_date/stock_30min/2006/2006-06-27.parquet
  size:    921 KB
  rows:    49,817
  symbols: 2,288

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
2006-06-27 07:00:00	AAPL	Stock	2.0946	2.0946	2.0893	2.0893	28000.0
2006-06-27 08:00:00	AAPL	Stock	2.1007	2.1029	2.0971	2.1	405300.0
2006-06-27 08:30:00	AAPL	Stock	2.1004	2.1036	2.1004	2.1029	114800.0
2006-06-27 09:00:00	AAPL	Stock	2.1039	2.1125	2.1018	2.11	701932.0
2006-06-27 09:30:00	AAPL	Stock	2.1104	2.115	2.0929	2.0961	47335372.0
2006-06-27 10:00:00	AAPL	Stock	2.0964	2.1025	2.0686	2.0729	86551584.0
2006-06-27 10:30:00	AAPL	Stock	2.0729	2.0807	2.0639	2.0657	55950524.0
2006-06-27 11:00:00	AAPL	Stock	2.0657	2.0739	2.0614	2.0725	59481268.0
2006-06-27 11:30:00	AAPL	Stock	2.0725	2.0743	2.0661	2.0689	22656508.0
2006-06-27 12:00:00	AAPL	Stock	2.0689	2.1116	2.0639	2.0679	22688344.0
2006-06-27 12:30:00	AAPL	Stock	2.0675	2.0686	2.0593	2.0618	28688380.0
2006-06-27 13:00:00	AAPL	Stock	2.0614	2.0711	2.0593	2.0689	26050780.0
2006-06-27 13:30:00	AAPL	Stock	2.0686	2.0704	2.0632	2.0668	12155024.0
2006-06-27 14:00:00	AAPL	Stock	2.0664	2.0711	2.0625	2.0643	22943256.0
2006-06-27 14:30:00	AAPL	Stock	2.0643	2.0671	2.0536	2.0582	35285516.0
2006-06-27 15:00:00	AAPL	Stock	2.0586	2.07	2.0568	2.0654	32377156.0
2006-06-27 15:30:00	AAPL	Stock	2.0654	2.0732	2.05	2.0511	59922716.0
2006-06-27 16:00:00	AAPL	Stock	2.0514	2.0518	2.0454	2.0468	2703232.0
2006-06-27 16:30:00	AAPL	Stock	2.0468	2.0511	2.0446	2.0489	2499420.0
2006-06-27 17:00:00	AAPL	Stock	2.0468	2.0486	2.0464	2.0486	183120.0
2006-06-27 17:30:00	AAPL	Stock	2.0464	2.0493	2.0464	2.0464	110600.0
2006-06-27 18:00:00	AAPL	Stock	2.0475	2.051	2.0464	2.0486	808696.0
2006-06-27 08:00:00	MSFT	Stock	22.8	22.86	22.8	22.86	9300.0
2006-06-27 08:30:00	MSFT	Stock	22.85	22.88	22.81	22.88	10971.0
2006-06-27 09:00:00	MSFT	Stock	22.85	22.91	22.84	22.89	71250.0
2006-06-27 09:30:00	MSFT	Stock	22.89	23.13	22.84	23.1	9760179.0
2006-06-27 10:00:00	MSFT	Stock	23.11	23.16	23.03	23.04	7022753.0
2006-06-27 10:30:00	MSFT	Stock	23.05	23.13	23.03	23.06	6413223.0
2006-06-27 11:00:00	MSFT	Stock	23.06	23.11	22.96	23.0	5901732.0
2006-06-27 11:30:00	MSFT	Stock	22.99	23.04	22.95	23.0	3536141.0
2006-06-27 12:00:00	MSFT	Stock	23.01	23.02	22.96	22.96	2781162.0
2006-06-27 12:30:00	MSFT	Stock	22.96	22.97	22.91	22.95	3664236.0
2006-06-27 13:00:00	MSFT	Stock	22.96	23.02	22.93	23.0	3114292.0
2006-06-27 13:30:00	MSFT	Stock	22.99	23.03	22.98	23.01	1738097.0
2006-06-27 14:00:00	MSFT	Stock	23.01	23.03	22.92	22.927	3894805.0
2006-06-27 14:30:00	MSFT	Stock	22.92	23.0	22.91	22.97	5207021.0
2006-06-27 15:00:00	MSFT	Stock	22.97	23.01	22.95	23.0	4839690.0
2006-06-27 15:30:00	MSFT	Stock	23.0	23.08	22.85	22.86	9201731.0
2006-06-27 16:00:00	MSFT	Stock	22.86	23.005	22.84	22.94	315547.0
2006-06-27 16:30:00	MSFT	Stock	22.82	22.89	22.82	22.89	3259371.0
2006-06-27 17:00:00	MSFT	Stock	22.89	22.9	22.89	22.9	300.0
2006-06-27 17:30:00	MSFT	Stock	22.89	22.9	22.88	22.88	5300.0
2006-06-27 18:00:00	MSFT	Stock	22.859	22.88	22.859	22.86	216308.0
2006-06-27 08:00:00	NVDA	Stock	0.3358	0.3362	0.3358	0.3362	63000.0
2006-06-27 08:30:00	NVDA	Stock	0.339	0.3428	0.3355	0.3383	155400.0
2006-06-27 09:00:00	NVDA	Stock	0.3375	0.3375	0.3358	0.336	279480.0
2006-06-27 09:30:00	NVDA	Stock	0.3373	0.3377	0.3335	0.3342	26998200.0
2006-06-27 10:00:00	NVDA	Stock	0.3342	0.3348	0.3303	0.3322	50095800.0
2006-06-27 10:30:00	NVDA	Stock	0.3322	0.3327	0.3308	0.331	34277460.0
2006-06-27 11:00:00	NVDA	Stock	0.3308	0.3312	0.326	0.3275	53141580.0

> showing 50 of 49,817 rows — these rows as CSV

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