PREVIEW / stock_30min / 2010-03-10

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-03-10.parquet
  size:    1.4 MB
  rows:    75,376
  symbols: 3,452

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-03-10 06:30:00	AAPL	Stock	8.0007	8.0007	8.0007	8.0007	12824.0
2010-03-10 07:00:00	AAPL	Stock	8.0	8.0036	7.9964	8.0	114380.0
2010-03-10 07:30:00	AAPL	Stock	7.9964	8.0014	7.9932	8.0	88200.0
2010-03-10 08:00:00	AAPL	Stock	7.9946	8.0164	7.9946	8.0143	1798412.0
2010-03-10 08:30:00	AAPL	Stock	8.0143	8.0161	8.0039	8.0071	1241324.0
2010-03-10 09:00:00	AAPL	Stock	8.0073	8.01	7.9879	7.9946	1328460.0
2010-03-10 09:30:00	AAPL	Stock	7.9932	8.0318	7.9714	7.9957	81029284.0
2010-03-10 10:00:00	AAPL	Stock	7.9957	8.0179	7.9893	8.0146	51777768.0
2010-03-10 10:30:00	AAPL	Stock	8.015	8.0302	8.0043	8.0186	37407524.0
2010-03-10 11:00:00	AAPL	Stock	8.0193	8.0343	8.0193	8.0261	32932368.0
2010-03-10 11:30:00	AAPL	Stock	8.0271	8.0329	8.0093	8.0221	29688204.0
2010-03-10 12:00:00	AAPL	Stock	8.0221	8.03	7.9968	8.0036	31933244.0
2010-03-10 12:30:00	AAPL	Stock	8.0032	8.0314	7.9968	8.0257	26946808.0
2010-03-10 13:00:00	AAPL	Stock	8.0261	8.0407	8.0164	8.0207	32963420.0
2010-03-10 13:30:00	AAPL	Stock	8.02	8.0307	7.9982	8.0093	26793732.0
2010-03-10 14:00:00	AAPL	Stock	8.01	8.0307	8.0054	8.0296	24550148.0
2010-03-10 14:30:00	AAPL	Stock	8.0296	8.0529	8.0289	8.035	54179832.0
2010-03-10 15:00:00	AAPL	Stock	8.035	8.0446	8.0093	8.0118	32409720.0
2010-03-10 15:30:00	AAPL	Stock	8.0121	8.0357	8.0061	8.03	45227392.0
2010-03-10 16:00:00	AAPL	Stock	8.0307	8.0357	7.965	8.0346	4852540.0
2010-03-10 16:30:00	AAPL	Stock	8.0112	8.0393	8.0112	8.0393	463540.0
2010-03-10 17:00:00	AAPL	Stock	8.0343	8.0343	8.0321	8.0321	20384.0
2010-03-10 17:30:00	AAPL	Stock	8.0321	8.0368	8.0307	8.035	121828.0
2010-03-10 18:00:00	AAPL	Stock	8.035	8.035	8.0314	8.0321	61040.0
2010-03-10 18:30:00	AAPL	Stock	8.0311	8.0346	8.0304	8.0307	34804.0
2010-03-10 19:00:00	AAPL	Stock	8.0321	8.035	8.0279	8.0304	119280.0
2010-03-10 19:30:00	AAPL	Stock	8.0286	8.0296	8.0196	8.0196	233268.0
2010-03-10 08:00:00	MSFT	Stock	28.92	28.92	28.89	28.89	3600.0
2010-03-10 08:30:00	MSFT	Stock	28.89	28.93	28.85	28.9	20867.0
2010-03-10 09:00:00	MSFT	Stock	28.93	28.93	28.81	28.86	24040.0
2010-03-10 09:30:00	MSFT	Stock	28.86	28.89	28.8	28.85	3520594.0
2010-03-10 10:00:00	MSFT	Stock	28.85	28.99	28.85	28.98	4246594.0
2010-03-10 10:30:00	MSFT	Stock	28.99	29.11	28.97	29.01	4496306.0
2010-03-10 11:00:00	MSFT	Stock	29.01	29.08	28.95	28.99	2754360.0
2010-03-10 11:30:00	MSFT	Stock	29.0	29.05	28.91	28.98	2564481.0
2010-03-10 12:00:00	MSFT	Stock	28.981	29.0	28.9	28.92	2525225.0
2010-03-10 12:30:00	MSFT	Stock	28.91	28.96	28.87	28.95	3020634.0
2010-03-10 13:00:00	MSFT	Stock	28.95	29.02	28.92	28.975	2012194.0
2010-03-10 13:30:00	MSFT	Stock	28.98	29.04	28.945	28.955	1528864.0
2010-03-10 14:00:00	MSFT	Stock	28.96	29.04	28.93	29.01	2516097.0
2010-03-10 14:30:00	MSFT	Stock	29.012	29.025	28.955	28.98	2133266.0
2010-03-10 15:00:00	MSFT	Stock	28.97	29.05	28.94	28.95	3189449.0
2010-03-10 15:30:00	MSFT	Stock	28.94	28.98	28.91	28.97	6617265.0
2010-03-10 16:00:00	MSFT	Stock	28.97	28.98	28.94	28.97	3087530.0
2010-03-10 16:30:00	MSFT	Stock	28.933	28.97	28.933	28.97	57222.0
2010-03-10 17:00:00	MSFT	Stock	29.039	29.039	29.039	29.039	1700.0
2010-03-10 17:30:00	MSFT	Stock	28.99	28.99	28.99	28.99	200.0
2010-03-10 18:00:00	MSFT	Stock	28.96	28.99	28.96	28.99	1826.0
2010-03-10 19:00:00	MSFT	Stock	28.98	28.98	28.96	28.96	1000.0
2010-03-10 19:30:00	MSFT	Stock	28.95	28.98	28.95	28.96	4425.0

> showing 50 of 75,376 rows — these rows as CSV

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