PREVIEW / stock_30min / 2010-01-20

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-01-20.parquet
  size:    1.4 MB
  rows:    72,858
  symbols: 3,424

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
2010-01-20 04:00:00	AAPL	Stock	7.6786	7.6786	7.6714	7.6714	14000.0
2010-01-20 05:00:00	AAPL	Stock	7.665	7.6839	7.665	7.6839	16800.0
2010-01-20 06:00:00	AAPL	Stock	7.6836	7.6836	7.67	7.67	33600.0
2010-01-20 06:30:00	AAPL	Stock	7.6829	7.6829	7.6782	7.6782	71764.0
2010-01-20 07:00:00	AAPL	Stock	7.6714	7.6714	7.6521	7.6679	182644.0
2010-01-20 07:30:00	AAPL	Stock	7.6586	7.6786	7.6586	7.6786	258104.0
2010-01-20 08:00:00	AAPL	Stock	7.6732	7.6839	7.6539	7.6636	1715280.0
2010-01-20 08:30:00	AAPL	Stock	7.6629	7.6654	7.6396	7.6518	1024268.0
2010-01-20 09:00:00	AAPL	Stock	7.6486	7.675	7.6357	7.6732	2142952.0
2010-01-20 09:30:00	AAPL	Stock	7.6729	7.6982	7.5768	7.5932	102129720.0
2010-01-20 10:00:00	AAPL	Stock	7.5932	7.6029	7.5079	7.515	90469680.0
2010-01-20 10:30:00	AAPL	Stock	7.5146	7.5386	7.5011	7.5132	62809684.0
2010-01-20 11:00:00	AAPL	Stock	7.5143	7.5407	7.4821	7.5104	55967016.0
2010-01-20 11:30:00	AAPL	Stock	7.5104	7.5343	7.5004	7.5164	39054932.0
2010-01-20 12:00:00	AAPL	Stock	7.5161	7.5514	7.5125	7.5511	27056960.0
2010-01-20 12:30:00	AAPL	Stock	7.5511	7.5564	7.5179	7.5232	29063020.0
2010-01-20 13:00:00	AAPL	Stock	7.5236	7.5268	7.5054	7.5116	19618032.0
2010-01-20 13:30:00	AAPL	Stock	7.5121	7.5471	7.5061	7.5388	29329272.0
2010-01-20 14:00:00	AAPL	Stock	7.5393	7.5454	7.5232	7.5275	21221508.0
2010-01-20 14:30:00	AAPL	Stock	7.5287	7.5518	7.5246	7.5382	30782080.0
2010-01-20 15:00:00	AAPL	Stock	7.5382	7.545	7.5236	7.5332	25794916.0
2010-01-20 15:30:00	AAPL	Stock	7.5329	7.5704	7.5232	7.5654	58760884.0
2010-01-20 16:00:00	AAPL	Stock	7.5693	7.6741	7.5236	7.5621	6200740.0
2010-01-20 16:30:00	AAPL	Stock	7.5319	7.5696	7.5319	7.5657	717780.0
2010-01-20 17:00:00	AAPL	Stock	7.5686	7.5893	7.5686	7.5893	991424.0
2010-01-20 17:30:00	AAPL	Stock	7.5861	7.5911	7.5789	7.5807	264488.0
2010-01-20 18:00:00	AAPL	Stock	7.5821	7.5889	7.5614	7.5846	420084.0
2010-01-20 18:30:00	AAPL	Stock	7.5846	7.5846	7.5768	7.5768	210196.0
2010-01-20 19:00:00	AAPL	Stock	7.5818	7.5871	7.5818	7.5857	147084.0
2010-01-20 19:30:00	AAPL	Stock	7.5839	7.5871	7.5789	7.5871	76720.0
2010-01-20 05:30:00	MSFT	Stock	30.93	30.93	30.89	30.89	400.0
2010-01-20 06:30:00	MSFT	Stock	30.85	30.85	30.85	30.85	150.0
2010-01-20 07:00:00	MSFT	Stock	30.77	30.88	30.77	30.88	3187.0
2010-01-20 07:30:00	MSFT	Stock	30.88	30.88	30.88	30.88	187.0
2010-01-20 08:00:00	MSFT	Stock	30.95	30.95	30.91	30.93	704.0
2010-01-20 08:30:00	MSFT	Stock	30.95	30.98	30.92	30.92	6073.0
2010-01-20 09:00:00	MSFT	Stock	30.93	30.93	30.8	30.8	64600.0
2010-01-20 09:30:00	MSFT	Stock	30.8	30.94	30.53	30.64	7523339.0
2010-01-20 10:00:00	MSFT	Stock	30.64	30.7	30.35	30.38	6895845.0
2010-01-20 10:30:00	MSFT	Stock	30.37	30.56	30.35	30.44	4886129.0
2010-01-20 11:00:00	MSFT	Stock	30.432	30.49	30.31	30.47	4942284.0
2010-01-20 11:30:00	MSFT	Stock	30.47	30.5	30.4	30.42	2781195.0
2010-01-20 12:00:00	MSFT	Stock	30.43	30.49	30.4	30.427	2188828.0
2010-01-20 12:30:00	MSFT	Stock	30.42	30.44	30.36	30.39	2130577.0
2010-01-20 13:00:00	MSFT	Stock	30.39	30.47	30.36	30.4	2772836.0
2010-01-20 13:30:00	MSFT	Stock	30.4	30.52	30.38	30.48	2135326.0
2010-01-20 14:00:00	MSFT	Stock	30.48	30.51	30.42	30.49	1924089.0
2010-01-20 14:30:00	MSFT	Stock	30.48	30.54	30.47	30.5	1883727.0
2010-01-20 15:00:00	MSFT	Stock	30.492	30.55	30.47	30.51	3070673.0
2010-01-20 15:30:00	MSFT	Stock	30.52	30.62	30.47	30.58	4858474.0

> showing 50 of 72,858 rows — these rows as CSV

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