PREVIEW / stock_30min / 2009-12-24

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-12-24.parquet
  size:    813 KB
  rows:    39,847
  symbols: 3,372

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-12-24 07:00:00	AAPL	Stock	7.25	7.25	7.2361	7.25	49140.0
2009-12-24 07:30:00	AAPL	Stock	7.2536	7.2589	7.2496	7.25	472780.0
2009-12-24 08:00:00	AAPL	Stock	7.25	7.2661	7.2429	7.2571	1480640.0
2009-12-24 08:30:00	AAPL	Stock	7.2568	7.2786	7.2568	7.2679	1501192.0
2009-12-24 09:00:00	AAPL	Stock	7.265	7.2836	7.2646	7.275	2405368.0
2009-12-24 09:30:00	AAPL	Stock	7.2696	7.3911	7.2611	7.3832	118040580.0
2009-12-24 10:00:00	AAPL	Stock	7.3836	7.4286	7.3818	7.4052	92397928.0
2009-12-24 10:30:00	AAPL	Stock	7.405	7.4204	7.3954	7.4073	36315692.0
2009-12-24 11:00:00	AAPL	Stock	7.4072	7.4475	7.4057	7.4419	55921572.0
2009-12-24 11:30:00	AAPL	Stock	7.4409	7.4768	7.4375	7.4643	67193000.0
2009-12-24 12:00:00	AAPL	Stock	7.4643	7.4693	7.4339	7.4572	43908200.0
2009-12-24 12:30:00	AAPL	Stock	7.4575	7.4722	7.4346	7.4646	72219700.0
2009-12-24 13:00:00	AAPL	Stock	7.4646	7.4714	7.4123	7.4664	4545324.0
2009-12-24 13:30:00	AAPL	Stock	7.4671	7.4679	7.4643	7.4671	329672.0
2009-12-24 14:00:00	AAPL	Stock	7.4671	7.4696	7.4654	7.4696	225624.0
2009-12-24 14:30:00	AAPL	Stock	7.4679	7.4696	7.4643	7.4679	90300.0
2009-12-24 15:00:00	AAPL	Stock	7.4643	7.4679	7.4643	7.4646	73584.0
2009-12-24 15:30:00	AAPL	Stock	7.4654	7.4679	7.4643	7.4643	109032.0
2009-12-24 16:00:00	AAPL	Stock	7.4679	7.4679	7.4646	7.4679	53200.0
2009-12-24 16:30:00	AAPL	Stock	7.4679	7.4679	7.4679	7.4679	25480.0
2009-12-24 07:00:00	MSFT	Stock	30.86	30.86	30.86	30.86	100.0
2009-12-24 08:00:00	MSFT	Stock	30.89	30.96	30.88	30.95	5400.0
2009-12-24 08:30:00	MSFT	Stock	30.95	30.95	30.92	30.92	3300.0
2009-12-24 09:00:00	MSFT	Stock	30.92	30.93	30.84	30.88	46710.0
2009-12-24 09:30:00	MSFT	Stock	30.89	30.96	30.76	30.94	1786725.0
2009-12-24 10:00:00	MSFT	Stock	30.94	30.99	30.91	30.98	1320145.0
2009-12-24 10:30:00	MSFT	Stock	30.981	30.99	30.97	30.982	992323.0
2009-12-24 11:00:00	MSFT	Stock	30.99	30.99	30.98	30.981	802799.0
2009-12-24 11:30:00	MSFT	Stock	30.98	31.0	30.98	31.0	1918581.0
2009-12-24 12:00:00	MSFT	Stock	31.0	31.0	30.96	30.96	1558815.0
2009-12-24 12:30:00	MSFT	Stock	30.97	31.0	30.96	31.0	1862416.0
2009-12-24 13:00:00	MSFT	Stock	31.0	31.06	30.97	31.0	385858.0
2009-12-24 13:30:00	MSFT	Stock	31.03	31.03	30.98	31.0	5915.0
2009-12-24 14:00:00	MSFT	Stock	31.0	31.02	31.0	31.02	1298.0
2009-12-24 14:30:00	MSFT	Stock	30.99	30.99	30.99	30.99	200.0
2009-12-24 15:00:00	MSFT	Stock	30.99	31.0	30.98	30.98	1840.0
2009-12-24 15:30:00	MSFT	Stock	31.0	31.0	31.0	31.0	170.0
2009-12-24 16:00:00	MSFT	Stock	31.0	31.0	31.0	31.0	100.0
2009-12-24 16:30:00	MSFT	Stock	30.99	30.99	30.99	30.99	200.0
2009-12-24 08:00:00	NVDA	Stock	0.4542	0.4562	0.4525	0.4532	54000.0
2009-12-24 08:30:00	NVDA	Stock	0.4522	0.4522	0.4522	0.4522	4800.0
2009-12-24 09:30:00	NVDA	Stock	0.4545	0.4545	0.4518	0.4532	26549960.0
2009-12-24 10:00:00	NVDA	Stock	0.4532	0.4552	0.453	0.4535	25291760.0
2009-12-24 10:30:00	NVDA	Stock	0.4535	0.454	0.4518	0.4528	17421040.0
2009-12-24 11:00:00	NVDA	Stock	0.4525	0.4528	0.4505	0.452	12915840.0
2009-12-24 11:30:00	NVDA	Stock	0.4522	0.4525	0.4515	0.4518	12494320.0
2009-12-24 12:00:00	NVDA	Stock	0.4515	0.4528	0.4515	0.4518	11895320.0
2009-12-24 12:30:00	NVDA	Stock	0.4516	0.4522	0.4508	0.4522	26992400.0
2009-12-24 13:00:00	NVDA	Stock	0.4522	0.4532	0.4522	0.4524	2062200.0
2009-12-24 13:30:00	NVDA	Stock	0.4525	0.4525	0.4525	0.4525	5800.0

> showing 50 of 39,847 rows — these rows as CSV

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