PREVIEW / stock_30min / 2010-08-24

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-08-24.parquet
  size:    1.4 MB
  rows:    76,280
  symbols: 3,474

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-24 04:00:00	AAPL	Stock	8.75	8.75	8.75	8.75	11200.0
2010-08-24 07:00:00	AAPL	Stock	8.7232	8.7232	8.6964	8.6975	181888.0
2010-08-24 07:30:00	AAPL	Stock	8.6975	8.7089	8.6929	8.6957	188692.0
2010-08-24 08:00:00	AAPL	Stock	8.7036	8.7446	8.6607	8.6679	1820308.0
2010-08-24 08:30:00	AAPL	Stock	8.6746	8.6796	8.6418	8.6536	1556744.0
2010-08-24 09:00:00	AAPL	Stock	8.6486	8.6818	8.6361	8.675	1929788.0
2010-08-24 09:30:00	AAPL	Stock	8.6668	8.6786	8.5754	8.5875	113585836.0
2010-08-24 10:00:00	AAPL	Stock	8.5871	8.6189	8.5232	8.5875	110632088.0
2010-08-24 10:30:00	AAPL	Stock	8.5857	8.6411	8.5643	8.6386	45098956.0
2010-08-24 11:00:00	AAPL	Stock	8.6386	8.6771	8.6286	8.6621	42158788.0
2010-08-24 11:30:00	AAPL	Stock	8.6621	8.6786	8.6375	8.6393	28384244.0
2010-08-24 12:00:00	AAPL	Stock	8.6386	8.6575	8.6204	8.6225	22721832.0
2010-08-24 12:30:00	AAPL	Stock	8.6243	8.6339	8.6	8.6011	16733024.0
2010-08-24 13:00:00	AAPL	Stock	8.6018	8.63	8.5911	8.6297	19858580.0
2010-08-24 13:30:00	AAPL	Stock	8.6287	8.63	8.5875	8.5888	18677708.0
2010-08-24 14:00:00	AAPL	Stock	8.5893	8.6064	8.5818	8.5901	23738596.0
2010-08-24 14:30:00	AAPL	Stock	8.5904	8.6018	8.5721	8.5893	24740492.0
2010-08-24 15:00:00	AAPL	Stock	8.5906	8.6286	8.5796	8.6076	32509428.0
2010-08-24 15:30:00	AAPL	Stock	8.6082	8.6086	8.5664	8.5804	69972588.0
2010-08-24 16:00:00	AAPL	Stock	8.5804	8.7739	8.5689	8.5771	17722348.0
2010-08-24 16:30:00	AAPL	Stock	8.575	8.6091	8.5714	8.5757	1099140.0
2010-08-24 17:00:00	AAPL	Stock	8.6482	8.6482	8.5679	8.5693	2332148.0
2010-08-24 17:30:00	AAPL	Stock	8.5714	8.5714	8.5671	8.5714	82768.0
2010-08-24 18:00:00	AAPL	Stock	8.5682	8.5711	8.5393	8.55	284760.0
2010-08-24 18:30:00	AAPL	Stock	8.55	8.5525	8.5218	8.5475	575652.0
2010-08-24 19:00:00	AAPL	Stock	8.5386	8.5518	8.5286	8.5286	208068.0
2010-08-24 19:30:00	AAPL	Stock	8.5304	8.5679	8.5196	8.5661	665812.0
2010-08-24 05:30:00	MSFT	Stock	24.1	24.1	24.1	24.1	100.0
2010-08-24 07:00:00	MSFT	Stock	24.22	24.22	24.22	24.22	100.0
2010-08-24 07:30:00	MSFT	Stock	24.2	24.2	24.15	24.15	6400.0
2010-08-24 08:00:00	MSFT	Stock	24.18	24.19	24.1	24.12	14565.0
2010-08-24 08:30:00	MSFT	Stock	24.05	24.28	24.01	24.01	487258.0
2010-08-24 09:00:00	MSFT	Stock	24.01	24.11	24.01	24.09	44109.0
2010-08-24 09:30:00	MSFT	Stock	24.09	24.22	24.0	24.17	6857848.0
2010-08-24 10:00:00	MSFT	Stock	24.17	24.17	24.01	24.12	6134177.0
2010-08-24 10:30:00	MSFT	Stock	24.115	24.165	24.07	24.156	3334500.0
2010-08-24 11:00:00	MSFT	Stock	24.16	24.32	24.15	24.3	4994335.0
2010-08-24 11:30:00	MSFT	Stock	24.29	24.35	24.25	24.25	4107972.0
2010-08-24 12:00:00	MSFT	Stock	24.255	24.26	24.15	24.195	5284149.0
2010-08-24 12:30:00	MSFT	Stock	24.2	24.25	24.14	24.16	2277842.0
2010-08-24 13:00:00	MSFT	Stock	24.17	24.2	24.11	24.17	2502998.0
2010-08-24 13:30:00	MSFT	Stock	24.17	24.17	24.03	24.08	3266196.0
2010-08-24 14:00:00	MSFT	Stock	24.08	24.16	24.06	24.1	3132096.0
2010-08-24 14:30:00	MSFT	Stock	24.11	24.2	24.095	24.19	3701159.0
2010-08-24 15:00:00	MSFT	Stock	24.19	24.25	24.18	24.185	3838104.0
2010-08-24 15:30:00	MSFT	Stock	24.185	24.19	24.03	24.06	9259574.0
2010-08-24 16:00:00	MSFT	Stock	24.04	24.412	24.02	24.04	6239335.0
2010-08-24 16:30:00	MSFT	Stock	24.045	24.18	24.035	24.07	221084.0
2010-08-24 17:00:00	MSFT	Stock	24.22	24.22	24.04	24.04	213470.0
2010-08-24 17:30:00	MSFT	Stock	24.04	24.08	24.04	24.04	1800.0

> showing 50 of 76,280 rows — these rows as CSV

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