PREVIEW / stock_30min / 2010-08-26

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-08-26.parquet
  size:    1.3 MB
  rows:    73,602
  symbols: 3,467

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-08-26 04:00:00	AAPL	Stock	8.7096	8.75	8.7096	8.75	5600.0
2010-08-26 04:30:00	AAPL	Stock	8.75	8.75	8.75	8.75	3500.0
2010-08-26 05:00:00	AAPL	Stock	8.7143	8.7143	8.7143	8.7143	2800.0
2010-08-26 06:00:00	AAPL	Stock	8.7339	8.7371	8.7339	8.7371	19600.0
2010-08-26 06:30:00	AAPL	Stock	8.7161	8.7161	8.7143	8.7143	28000.0
2010-08-26 07:00:00	AAPL	Stock	8.7286	8.7286	8.6943	8.7107	280000.0
2010-08-26 07:30:00	AAPL	Stock	8.7107	8.7143	8.6975	8.6975	52500.0
2010-08-26 08:00:00	AAPL	Stock	8.7018	8.7036	8.6625	8.6829	920640.0
2010-08-26 08:30:00	AAPL	Stock	8.6871	8.7564	8.6871	8.7532	4959808.0
2010-08-26 09:00:00	AAPL	Stock	8.7507	8.7679	8.7332	8.7664	2572192.0
2010-08-26 09:30:00	AAPL	Stock	8.7632	8.7679	8.7007	8.7375	74673004.0
2010-08-26 10:00:00	AAPL	Stock	8.7357	8.7768	8.7336	8.7564	51713200.0
2010-08-26 10:30:00	AAPL	Stock	8.7582	8.7704	8.7286	8.7411	33399912.0
2010-08-26 11:00:00	AAPL	Stock	8.7427	8.7457	8.6864	8.7139	34222552.0
2010-08-26 11:30:00	AAPL	Stock	8.7139	8.725	8.6582	8.6893	35173404.0
2010-08-26 12:00:00	AAPL	Stock	8.6875	8.6989	8.6657	8.6907	15315048.0
2010-08-26 12:30:00	AAPL	Stock	8.6921	8.7071	8.6714	8.6846	14107632.0
2010-08-26 13:00:00	AAPL	Stock	8.6841	8.6907	8.6711	8.6829	13144852.0
2010-08-26 13:30:00	AAPL	Stock	8.6829	8.6911	8.6475	8.648	20000148.0
2010-08-26 14:00:00	AAPL	Stock	8.6475	8.6578	8.61	8.6229	30842336.0
2010-08-26 14:30:00	AAPL	Stock	8.6229	8.6389	8.5943	8.6011	31611384.0
2010-08-26 15:00:00	AAPL	Stock	8.6014	8.6289	8.5857	8.6122	32796540.0
2010-08-26 15:30:00	AAPL	Stock	8.6114	8.6339	8.5814	8.5818	41707932.0
2010-08-26 16:00:00	AAPL	Stock	8.5814	8.7601	8.5757	8.5821	18081952.0
2010-08-26 16:30:00	AAPL	Stock	8.5807	8.6085	8.5779	8.5875	2862412.0
2010-08-26 17:00:00	AAPL	Stock	8.5875	8.5893	8.5718	8.5725	548744.0
2010-08-26 17:30:00	AAPL	Stock	8.5729	8.5814	8.5679	8.5686	513380.0
2010-08-26 18:00:00	AAPL	Stock	8.5682	8.5814	8.5357	8.5714	455616.0
2010-08-26 18:30:00	AAPL	Stock	8.5711	8.5714	8.5661	8.5671	102256.0
2010-08-26 19:00:00	AAPL	Stock	8.5696	8.5714	8.5671	8.5671	90944.0
2010-08-26 19:30:00	AAPL	Stock	8.5675	8.5732	8.5661	8.5732	148540.0
2010-08-26 07:30:00	MSFT	Stock	24.21	24.21	24.21	24.21	500.0
2010-08-26 08:00:00	MSFT	Stock	24.17	24.17	24.0	24.08	5825.0
2010-08-26 08:30:00	MSFT	Stock	24.12	24.27	24.12	24.23	43175.0
2010-08-26 09:00:00	MSFT	Stock	24.21	24.22	24.06	24.1	71782.0
2010-08-26 09:30:00	MSFT	Stock	24.1	24.17	24.03	24.14	4212210.0
2010-08-26 10:00:00	MSFT	Stock	24.14	24.19	24.11	24.12	2709787.0
2010-08-26 10:30:00	MSFT	Stock	24.11	24.14	24.05	24.07	2600261.0
2010-08-26 11:00:00	MSFT	Stock	24.08	24.09	23.95	24.0	3367335.0
2010-08-26 11:30:00	MSFT	Stock	24.01	24.04	23.92	24.02	3772803.0
2010-08-26 12:00:00	MSFT	Stock	24.022	24.04	23.95	23.972	1817981.0
2010-08-26 12:30:00	MSFT	Stock	23.97	23.99	23.91	23.955	1776752.0
2010-08-26 13:00:00	MSFT	Stock	23.96	23.97	23.9	23.94	1646521.0
2010-08-26 13:30:00	MSFT	Stock	23.93	23.96	23.91	23.92	2793084.0
2010-08-26 14:00:00	MSFT	Stock	23.92	23.94	23.83	23.86	2681655.0
2010-08-26 14:30:00	MSFT	Stock	23.86	23.9	23.79	23.795	3892722.0
2010-08-26 15:00:00	MSFT	Stock	23.795	23.91	23.79	23.86	3197355.0
2010-08-26 15:30:00	MSFT	Stock	23.86	23.99	23.81	23.81	6489626.0
2010-08-26 16:00:00	MSFT	Stock	23.83	23.974	23.76	23.83	5748962.0
2010-08-26 16:30:00	MSFT	Stock	23.82	23.98	23.77	23.77	1261559.0

> showing 50 of 73,602 rows — these rows as CSV

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