PREVIEW / stock_30min / 2010-09-08

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-09-08.parquet
  size:    1.3 MB
  rows:    71,558
  symbols: 3,468

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-09-08 04:00:00	AAPL	Stock	9.1968	9.1968	9.1968	9.1968	2800.0
2010-09-08 04:30:00	AAPL	Stock	9.1679	9.1679	9.1679	9.1679	2800.0
2010-09-08 05:00:00	AAPL	Stock	9.1679	9.1679	9.1679	9.1679	13160.0
2010-09-08 05:30:00	AAPL	Stock	9.1679	9.1679	9.1679	9.1679	9240.0
2010-09-08 06:30:00	AAPL	Stock	9.2286	9.2286	9.2143	9.2143	18480.0
2010-09-08 07:00:00	AAPL	Stock	9.2221	9.25	9.2221	9.25	135100.0
2010-09-08 07:30:00	AAPL	Stock	9.25	9.3043	9.2418	9.2875	294140.0
2010-09-08 08:00:00	AAPL	Stock	9.2896	9.3075	9.2546	9.2843	3214428.0
2010-09-08 08:30:00	AAPL	Stock	9.2836	9.2854	9.2661	9.2661	1200164.0
2010-09-08 09:00:00	AAPL	Stock	9.2707	9.28	9.2589	9.2786	780052.0
2010-09-08 09:30:00	AAPL	Stock	9.2779	9.3411	9.2536	9.3411	89773348.0
2010-09-08 10:00:00	AAPL	Stock	9.3407	9.3664	9.3293	9.3514	65563036.0
2010-09-08 10:30:00	AAPL	Stock	9.3514	9.3679	9.3482	9.3529	31315564.0
2010-09-08 11:00:00	AAPL	Stock	9.3522	9.3907	9.3521	9.3886	33455996.0
2010-09-08 11:30:00	AAPL	Stock	9.39	9.3946	9.3761	9.3854	24188220.0
2010-09-08 12:00:00	AAPL	Stock	9.3861	9.4354	9.385	9.4339	33864264.0
2010-09-08 12:30:00	AAPL	Stock	9.4311	9.4425	9.4161	9.4311	27035540.0
2010-09-08 13:00:00	AAPL	Stock	9.4311	9.4332	9.4132	9.4154	21123956.0
2010-09-08 13:30:00	AAPL	Stock	9.4164	9.4214	9.375	9.3879	31396540.0
2010-09-08 14:00:00	AAPL	Stock	9.3882	9.4071	9.3657	9.4021	35448952.0
2010-09-08 14:30:00	AAPL	Stock	9.4032	9.4282	9.4006	9.4129	23617272.0
2010-09-08 15:00:00	AAPL	Stock	9.4118	9.4325	9.3975	9.3975	35069776.0
2010-09-08 15:30:00	AAPL	Stock	9.3989	9.4225	9.3704	9.3896	51846116.0
2010-09-08 16:00:00	AAPL	Stock	9.39	9.405	9.385	9.3914	13740468.0
2010-09-08 16:30:00	AAPL	Stock	9.3875	9.4051	9.3009	9.3896	387436.0
2010-09-08 17:00:00	AAPL	Stock	9.39	9.4	9.3893	9.3982	363972.0
2010-09-08 17:30:00	AAPL	Stock	9.3986	9.3986	9.395	9.3982	39648.0
2010-09-08 18:00:00	AAPL	Stock	9.3982	9.4079	9.2479	9.3996	635740.0
2010-09-08 18:30:00	AAPL	Stock	9.4	9.4054	9.3968	9.3996	139188.0
2010-09-08 19:00:00	AAPL	Stock	9.3993	9.4036	9.3971	9.4036	38388.0
2010-09-08 19:30:00	AAPL	Stock	9.4	9.4104	9.3993	9.4043	82012.0
2010-09-08 07:00:00	MSFT	Stock	24.04	24.04	24.04	24.04	531.0
2010-09-08 07:30:00	MSFT	Stock	24.0	24.0	24.0	24.0	100.0
2010-09-08 08:00:00	MSFT	Stock	24.0	24.05	24.0	24.05	4205.0
2010-09-08 08:30:00	MSFT	Stock	24.05	24.05	24.0	24.0	5798.0
2010-09-08 09:00:00	MSFT	Stock	24.0	24.1	24.0	24.05	56658.0
2010-09-08 09:30:00	MSFT	Stock	24.07	24.1	24.0	24.06	4657460.0
2010-09-08 10:00:00	MSFT	Stock	24.06	24.12	24.04	24.1	4143807.0
2010-09-08 10:30:00	MSFT	Stock	24.1	24.2	24.09	24.138	3252701.0
2010-09-08 11:00:00	MSFT	Stock	24.13	24.17	24.06	24.09	3450007.0
2010-09-08 11:30:00	MSFT	Stock	24.09	24.1	23.96	24.01	4283994.0
2010-09-08 12:00:00	MSFT	Stock	24.01	24.02	23.96	24.01	4572188.0
2010-09-08 12:30:00	MSFT	Stock	24.01	24.01	23.975	24.0	3350771.0
2010-09-08 13:00:00	MSFT	Stock	24.0	24.0	23.95	23.965	2879704.0
2010-09-08 13:30:00	MSFT	Stock	23.965	23.98	23.8	23.81	6785472.0
2010-09-08 14:00:00	MSFT	Stock	23.815	23.86	23.74	23.82	7131333.0
2010-09-08 14:30:00	MSFT	Stock	23.82	23.94	23.81	23.9	4763435.0
2010-09-08 15:00:00	MSFT	Stock	23.903	24.01	23.89	23.91	4874559.0
2010-09-08 15:30:00	MSFT	Stock	23.918	23.98	23.89	23.92	7692057.0
2010-09-08 16:00:00	MSFT	Stock	23.92	24.051	23.81	24.023	2429102.0

> showing 50 of 71,558 rows — these rows as CSV

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