PREVIEW / stock_30min / 2011-02-25

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-02-25.parquet
  size:    1.5 MB
  rows:    79,078
  symbols: 3,538

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
2011-02-25 04:00:00	AAPL	Stock	12.3196	12.3196	12.3196	12.3196	2800.0
2011-02-25 04:30:00	AAPL	Stock	12.3386	12.3525	12.3386	12.3525	8400.0
2011-02-25 05:00:00	AAPL	Stock	12.3429	12.3536	12.3429	12.3536	41916.0
2011-02-25 05:30:00	AAPL	Stock	12.3393	12.3479	12.3393	12.3479	16240.0
2011-02-25 06:00:00	AAPL	Stock	12.3564	12.3564	12.3393	12.3393	28000.0
2011-02-25 06:30:00	AAPL	Stock	12.3393	12.3568	12.3393	12.3568	65156.0
2011-02-25 07:00:00	AAPL	Stock	12.35	12.3554	12.3393	12.3393	187012.0
2011-02-25 07:30:00	AAPL	Stock	12.3354	12.3393	12.3136	12.33	368760.0
2011-02-25 08:00:00	AAPL	Stock	12.3293	12.3368	12.2996	12.3196	950012.0
2011-02-25 08:30:00	AAPL	Stock	12.3193	12.3286	12.2457	12.3232	673540.0
2011-02-25 09:00:00	AAPL	Stock	12.3168	12.3382	12.3161	12.3311	951944.0
2011-02-25 09:30:00	AAPL	Stock	12.33	12.3696	12.3143	12.3432	67463312.0
2011-02-25 10:00:00	AAPL	Stock	12.3446	12.3857	12.3382	12.3693	39937044.0
2011-02-25 10:30:00	AAPL	Stock	12.37	12.4296	12.3626	12.4175	38184356.0
2011-02-25 11:00:00	AAPL	Stock	12.4175	12.4386	12.3946	12.4025	32423552.0
2011-02-25 11:30:00	AAPL	Stock	12.4036	12.4154	12.3668	12.3846	30442608.0
2011-02-25 12:00:00	AAPL	Stock	12.3836	12.4229	12.3789	12.4136	15101800.0
2011-02-25 12:30:00	AAPL	Stock	12.4157	12.4264	12.4075	12.4205	12876612.0
2011-02-25 13:00:00	AAPL	Stock	12.4228	12.4286	12.3821	12.4167	25226432.0
2011-02-25 13:30:00	AAPL	Stock	12.4154	12.4261	12.4018	12.4143	13742736.0
2011-02-25 14:00:00	AAPL	Stock	12.4139	12.4213	12.3929	12.4003	14367360.0
2011-02-25 14:30:00	AAPL	Stock	12.3996	12.4196	12.3982	12.4146	15457960.0
2011-02-25 15:00:00	AAPL	Stock	12.4154	12.4254	12.4043	12.4182	17479196.0
2011-02-25 15:30:00	AAPL	Stock	12.4179	12.4439	12.4164	12.4389	36259832.0
2011-02-25 16:00:00	AAPL	Stock	12.4343	12.4429	12.3939	12.4396	12552176.0
2011-02-25 16:30:00	AAPL	Stock	12.4396	12.44	12.3266	12.4332	1033928.0
2011-02-25 17:00:00	AAPL	Stock	12.435	12.4382	12.3701	12.4357	248192.0
2011-02-25 17:30:00	AAPL	Stock	12.3939	12.4364	12.3939	12.4321	1640016.0
2011-02-25 18:00:00	AAPL	Stock	12.4321	12.4404	12.4311	12.44	222936.0
2011-02-25 18:30:00	AAPL	Stock	12.4407	12.4457	12.4393	12.4457	300440.0
2011-02-25 19:00:00	AAPL	Stock	12.4464	12.4529	12.4464	12.4525	102676.0
2011-02-25 19:30:00	AAPL	Stock	12.4529	12.4643	12.4464	12.4643	147112.0
2011-02-25 07:00:00	MSFT	Stock	26.9	26.9	26.9	26.9	700.0
2011-02-25 07:30:00	MSFT	Stock	26.95	26.95	26.87	26.88	3300.0
2011-02-25 08:00:00	MSFT	Stock	26.88	26.93	26.86	26.88	14154.0
2011-02-25 08:30:00	MSFT	Stock	26.88	26.97	26.88	26.95	13924.0
2011-02-25 09:00:00	MSFT	Stock	26.92	26.97	26.81	26.91	65954.0
2011-02-25 09:30:00	MSFT	Stock	26.92	26.93	26.65	26.925	5805727.0
2011-02-25 10:00:00	MSFT	Stock	26.92	26.95	26.81	26.825	3509015.0
2011-02-25 10:30:00	MSFT	Stock	26.83	26.87	26.795	26.822	2700681.0
2011-02-25 11:00:00	MSFT	Stock	26.83	26.83	26.66	26.72	4027831.0
2011-02-25 11:30:00	MSFT	Stock	26.714	26.73	26.65	26.68	2649223.0
2011-02-25 12:00:00	MSFT	Stock	26.68	26.7	26.66	26.695	2441003.0
2011-02-25 12:30:00	MSFT	Stock	26.698	26.74	26.68	26.71	2553384.0
2011-02-25 13:00:00	MSFT	Stock	26.7	26.73	26.7	26.7	1631921.0
2011-02-25 13:30:00	MSFT	Stock	26.7	26.73	26.65	26.719	3454332.0
2011-02-25 14:00:00	MSFT	Stock	26.72	26.72	26.65	26.655	2316418.0
2011-02-25 14:30:00	MSFT	Stock	26.657	26.71	26.65	26.68	3155055.0
2011-02-25 15:00:00	MSFT	Stock	26.68	26.69	26.625	26.635	4373629.0
2011-02-25 15:30:00	MSFT	Stock	26.631	26.66	26.5	26.546	9976919.0

> showing 50 of 79,078 rows — these rows as CSV

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