PREVIEW / stock_30min / 2010-10-27

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-10-27.parquet
  size:    1.4 MB
  rows:    75,538
  symbols: 3,499

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-10-27 05:00:00	AAPL	Stock	10.9843	10.9843	10.9839	10.9839	8400.0
2010-10-27 05:30:00	AAPL	Stock	10.9821	10.9821	10.9821	10.9821	2800.0
2010-10-27 07:00:00	AAPL	Stock	10.9821	10.9921	10.9661	10.9739	109760.0
2010-10-27 07:30:00	AAPL	Stock	10.9739	10.9739	10.9446	10.9511	417200.0
2010-10-27 08:00:00	AAPL	Stock	10.95	10.9761	10.9429	10.975	936684.0
2010-10-27 08:30:00	AAPL	Stock	10.9721	11.0446	10.9589	11.0129	6061440.0
2010-10-27 09:00:00	AAPL	Stock	11.0089	11.0111	10.9732	10.9861	1641136.0
2010-10-27 09:30:00	AAPL	Stock	10.985	11.0679	10.9579	11.0039	74176228.0
2010-10-27 10:00:00	AAPL	Stock	11.006	11.0143	10.9364	10.95	43280272.0
2010-10-27 10:30:00	AAPL	Stock	10.9518	10.9779	10.9336	10.935	27829228.0
2010-10-27 11:00:00	AAPL	Stock	10.9382	10.9546	10.9143	10.9286	31389876.0
2010-10-27 11:30:00	AAPL	Stock	10.9261	10.9643	10.9254	10.9536	21169036.0
2010-10-27 12:00:00	AAPL	Stock	10.9518	10.9554	10.9411	10.95	9357152.0
2010-10-27 12:30:00	AAPL	Stock	10.9514	10.9568	10.9296	10.9368	10578232.0
2010-10-27 13:00:00	AAPL	Stock	10.9375	10.9664	10.92	10.9568	19824588.0
2010-10-27 13:30:00	AAPL	Stock	10.9546	10.9711	10.9439	10.9685	13827744.0
2010-10-27 14:00:00	AAPL	Stock	10.9683	10.9711	10.9482	10.9525	11977252.0
2010-10-27 14:30:00	AAPL	Stock	10.9537	10.9875	10.9446	10.9671	23104956.0
2010-10-27 15:00:00	AAPL	Stock	10.9675	10.975	10.9357	10.9571	18256672.0
2010-10-27 15:30:00	AAPL	Stock	10.9571	10.9996	10.9571	10.9896	40379136.0
2010-10-27 16:00:00	AAPL	Stock	10.9939	10.9952	10.9571	10.9757	12327224.0
2010-10-27 16:30:00	AAPL	Stock	10.9775	10.9794	10.85	10.9414	13436864.0
2010-10-27 17:00:00	AAPL	Stock	10.9357	10.9464	10.9111	10.9254	9955064.0
2010-10-27 17:30:00	AAPL	Stock	10.925	10.9939	10.9171	10.925	2221772.0
2010-10-27 18:00:00	AAPL	Stock	10.9236	10.9939	10.9125	10.9204	1560412.0
2010-10-27 18:30:00	AAPL	Stock	10.9146	10.9189	10.8929	10.8971	1232840.0
2010-10-27 19:00:00	AAPL	Stock	10.8968	10.9282	10.8964	10.9221	870996.0
2010-10-27 19:30:00	AAPL	Stock	10.9246	10.9311	10.9143	10.93	1132796.0
2010-10-27 07:00:00	MSFT	Stock	25.75	25.75	25.75	25.75	100.0
2010-10-27 07:30:00	MSFT	Stock	25.92	25.93	25.8	25.82	10810.0
2010-10-27 08:00:00	MSFT	Stock	25.81	25.88	25.81	25.83	8455.0
2010-10-27 08:30:00	MSFT	Stock	25.83	25.84	25.73	25.75	60522.0
2010-10-27 09:00:00	MSFT	Stock	25.75	25.8	25.72	25.79	115715.0
2010-10-27 09:30:00	MSFT	Stock	25.79	25.89	25.68	25.83	6822410.0
2010-10-27 10:00:00	MSFT	Stock	25.84	25.87	25.72	25.75	5589674.0
2010-10-27 10:30:00	MSFT	Stock	25.75	25.87	25.75	25.8	3839364.0
2010-10-27 11:00:00	MSFT	Stock	25.802	25.85	25.76	25.79	3860818.0
2010-10-27 11:30:00	MSFT	Stock	25.78	25.85	25.76	25.76	2789605.0
2010-10-27 12:00:00	MSFT	Stock	25.76	25.78	25.7	25.7	2336166.0
2010-10-27 12:30:00	MSFT	Stock	25.708	25.72	25.66	25.705	4278508.0
2010-10-27 13:00:00	MSFT	Stock	25.7	25.76	25.62	25.71	2840671.0
2010-10-27 13:30:00	MSFT	Stock	25.707	25.8	25.65	25.795	2649103.0
2010-10-27 14:00:00	MSFT	Stock	25.79	25.88	25.76	25.85	3254079.0
2010-10-27 14:30:00	MSFT	Stock	25.85	26.0	25.83	25.96	4886314.0
2010-10-27 15:00:00	MSFT	Stock	25.97	26.02	25.89	25.97	5946334.0
2010-10-27 15:30:00	MSFT	Stock	25.98	26.11	25.96	26.06	9469476.0
2010-10-27 16:00:00	MSFT	Stock	26.05	26.12	25.855	26.1	2966926.0
2010-10-27 16:30:00	MSFT	Stock	26.1	26.1	25.8	26.09	88774.0
2010-10-27 17:00:00	MSFT	Stock	26.08	26.08	26.03	26.07	28483.0
2010-10-27 17:30:00	MSFT	Stock	26.07	26.07	26.03	26.03	75407.0

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

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