PREVIEW / stock_30min / 2010-07-27

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-07-27.parquet
  size:    1.4 MB
  rows:    73,247
  symbols: 3,465

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-07-27 05:00:00	AAPL	Stock	9.2718	9.2718	9.25	9.25	12348.0
2010-07-27 05:30:00	AAPL	Stock	9.26	9.26	9.26	9.26	14000.0
2010-07-27 06:00:00	AAPL	Stock	9.2507	9.2679	9.2507	9.2679	12600.0
2010-07-27 06:30:00	AAPL	Stock	9.2693	9.2693	9.2693	9.2693	8400.0
2010-07-27 07:00:00	AAPL	Stock	9.2689	9.2693	9.2321	9.2321	71400.0
2010-07-27 07:30:00	AAPL	Stock	9.2339	9.2339	9.2104	9.2282	299600.0
2010-07-27 08:00:00	AAPL	Stock	9.2282	9.2818	9.2143	9.2679	990108.0
2010-07-27 08:30:00	AAPL	Stock	9.2711	9.3193	9.2704	9.2979	2972872.0
2010-07-27 09:00:00	AAPL	Stock	9.2982	9.3339	9.2879	9.3171	3315312.0
2010-07-27 09:30:00	AAPL	Stock	9.3168	9.4071	9.2964	9.3979	107616572.0
2010-07-27 10:00:00	AAPL	Stock	9.3954	9.4193	9.3464	9.4004	76302268.0
2010-07-27 10:30:00	AAPL	Stock	9.4014	9.4054	9.3604	9.3661	39492824.0
2010-07-27 11:00:00	AAPL	Stock	9.3674	9.3732	9.3268	9.36	33853624.0
2010-07-27 11:30:00	AAPL	Stock	9.3607	9.3885	9.357	9.3871	23835672.0
2010-07-27 12:00:00	AAPL	Stock	9.3879	9.4143	9.3768	9.4056	34889540.0
2010-07-27 12:30:00	AAPL	Stock	9.4037	9.4204	9.3876	9.4071	30013620.0
2010-07-27 13:00:00	AAPL	Stock	9.4073	9.4073	9.3821	9.3868	24641400.0
2010-07-27 13:30:00	AAPL	Stock	9.3861	9.4232	9.3832	9.4107	28926744.0
2010-07-27 14:00:00	AAPL	Stock	9.41	9.4418	9.4029	9.4389	42891744.0
2010-07-27 14:30:00	AAPL	Stock	9.4404	9.4446	9.4179	9.4371	28241080.0
2010-07-27 15:00:00	AAPL	Stock	9.4371	9.4571	9.4282	9.4536	37701832.0
2010-07-27 15:30:00	AAPL	Stock	9.4559	9.4564	9.425	9.4318	51460416.0
2010-07-27 16:00:00	AAPL	Stock	9.4304	9.4385	9.2648	9.4339	7775292.0
2010-07-27 16:30:00	AAPL	Stock	9.4314	9.4314	9.3026	9.4314	217560.0
2010-07-27 17:00:00	AAPL	Stock	9.4318	9.4339	9.4257	9.4257	108108.0
2010-07-27 17:30:00	AAPL	Stock	9.4257	9.4375	9.4257	9.4375	215516.0
2010-07-27 18:00:00	AAPL	Stock	9.4393	9.4414	9.4314	9.4386	3334660.0
2010-07-27 18:30:00	AAPL	Stock	9.4357	9.4404	9.4336	9.4336	42616.0
2010-07-27 19:00:00	AAPL	Stock	9.4332	9.4375	9.4257	9.4257	241808.0
2010-07-27 19:30:00	AAPL	Stock	9.4286	9.4404	9.4286	9.4321	176204.0
2010-07-27 06:30:00	MSFT	Stock	26.35	26.37	26.24	26.24	2400.0
2010-07-27 07:00:00	MSFT	Stock	26.24	26.3	26.24	26.28	7000.0
2010-07-27 07:30:00	MSFT	Stock	26.26	26.26	26.23	26.23	1050.0
2010-07-27 08:00:00	MSFT	Stock	26.25	26.27	26.2	26.27	37862.0
2010-07-27 08:30:00	MSFT	Stock	26.28	26.28	26.19	26.2	25302.0
2010-07-27 09:00:00	MSFT	Stock	26.2	26.24	26.09	26.11	252736.0
2010-07-27 09:30:00	MSFT	Stock	26.14	26.24	26.06	26.09	7156377.0
2010-07-27 10:00:00	MSFT	Stock	26.08	26.16	25.99	26.09	8910110.0
2010-07-27 10:30:00	MSFT	Stock	26.09	26.11	26.01	26.05	4116772.0
2010-07-27 11:00:00	MSFT	Stock	26.056	26.07	25.96	26.0	4567468.0
2010-07-27 11:30:00	MSFT	Stock	26.0	26.09	25.99	26.08	2919874.0
2010-07-27 12:00:00	MSFT	Stock	26.09	26.11	26.08	26.1	1618728.0
2010-07-27 12:30:00	MSFT	Stock	26.095	26.12	26.03	26.08	1987511.0
2010-07-27 13:00:00	MSFT	Stock	26.075	26.08	26.0	26.01	2159916.0
2010-07-27 13:30:00	MSFT	Stock	26.007	26.09	26.0	26.06	2072868.0
2010-07-27 14:00:00	MSFT	Stock	26.06	26.11	26.03	26.09	2592949.0
2010-07-27 14:30:00	MSFT	Stock	26.08	26.09	26.01	26.06	2542763.0
2010-07-27 15:00:00	MSFT	Stock	26.055	26.15	25.97	26.145	5554462.0
2010-07-27 15:30:00	MSFT	Stock	26.14	26.18	26.08	26.16	4959364.0
2010-07-27 16:00:00	MSFT	Stock	26.15	26.235	26.05	26.15	6468793.0

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

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