PREVIEW / stock_30min / 2011-10-25

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-10-25.parquet
  size:    1.4 MB
  rows:    73,994
  symbols: 3,476

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-10-25 04:00:00	AAPL	Stock	14.5282	14.5282	14.5179	14.5179	8400.0
2011-10-25 04:30:00	AAPL	Stock	14.5146	14.5146	14.5146	14.5146	5600.0
2011-10-25 05:30:00	AAPL	Stock	14.5286	14.5386	14.5286	14.5386	5600.0
2011-10-25 06:00:00	AAPL	Stock	14.5429	14.5429	14.5429	14.5429	2800.0
2011-10-25 06:30:00	AAPL	Stock	14.5446	14.5446	14.5429	14.5429	5600.0
2011-10-25 07:00:00	AAPL	Stock	14.5321	14.5464	14.5125	14.5464	144396.0
2011-10-25 07:30:00	AAPL	Stock	14.5429	14.5593	14.5096	14.5179	167440.0
2011-10-25 08:00:00	AAPL	Stock	14.52	14.5696	14.4379	14.4429	1095892.0
2011-10-25 08:30:00	AAPL	Stock	14.4536	14.5	14.4436	14.45	1042524.0
2011-10-25 09:00:00	AAPL	Stock	14.4536	14.4746	14.4304	14.4618	1104236.0
2011-10-25 09:30:00	AAPL	Stock	14.465	14.5196	14.2807	14.3486	96334644.0
2011-10-25 10:00:00	AAPL	Stock	14.3579	14.3832	14.3104	14.3589	38905132.0
2011-10-25 10:30:00	AAPL	Stock	14.3561	14.4132	14.3357	14.3757	34189176.0
2011-10-25 11:00:00	AAPL	Stock	14.3736	14.3954	14.3232	14.3393	21815220.0
2011-10-25 11:30:00	AAPL	Stock	14.3406	14.3464	14.29	14.299	21144032.0
2011-10-25 12:00:00	AAPL	Stock	14.2989	14.3496	14.2821	14.3304	17690932.0
2011-10-25 12:30:00	AAPL	Stock	14.3286	14.3421	14.2875	14.3036	15861216.0
2011-10-25 13:00:00	AAPL	Stock	14.305	14.345	14.3014	14.3125	11835152.0
2011-10-25 13:30:00	AAPL	Stock	14.3125	14.3175	14.2896	14.3036	13672848.0
2011-10-25 14:00:00	AAPL	Stock	14.3054	14.3082	14.2321	14.2404	37459044.0
2011-10-25 14:30:00	AAPL	Stock	14.2382	14.28	14.2096	14.2786	30515352.0
2011-10-25 15:00:00	AAPL	Stock	14.2786	14.2875	14.22	14.2414	24094336.0
2011-10-25 15:30:00	AAPL	Stock	14.245	14.2625	14.1921	14.2093	45787616.0
2011-10-25 16:00:00	AAPL	Stock	14.2146	14.3257	14.1343	14.1589	10270008.0
2011-10-25 16:30:00	AAPL	Stock	14.1486	14.2061	14.1475	14.1771	391384.0
2011-10-25 17:00:00	AAPL	Stock	14.4918	14.4918	14.1657	14.1786	738080.0
2011-10-25 17:30:00	AAPL	Stock	14.1846	14.1857	14.1786	14.1839	217028.0
2011-10-25 18:00:00	AAPL	Stock	14.1789	14.2061	14.1464	14.1686	312508.0
2011-10-25 18:30:00	AAPL	Stock	14.16	14.1607	14.1504	14.1607	58800.0
2011-10-25 19:00:00	AAPL	Stock	14.1643	14.1786	14.1521	14.1714	52780.0
2011-10-25 19:30:00	AAPL	Stock	14.1657	14.1875	14.1657	14.1657	82628.0
2011-10-25 05:00:00	MSFT	Stock	27.23	27.23	27.23	27.23	600.0
2011-10-25 06:00:00	MSFT	Stock	27.18	27.18	27.18	27.18	100.0
2011-10-25 06:30:00	MSFT	Stock	27.15	27.15	27.15	27.15	200.0
2011-10-25 07:30:00	MSFT	Stock	27.16	27.17	27.16	27.17	1250.0
2011-10-25 08:00:00	MSFT	Stock	27.17	27.22	27.16	27.16	1778.0
2011-10-25 08:30:00	MSFT	Stock	27.16	27.16	27.07	27.13	7691.0
2011-10-25 09:00:00	MSFT	Stock	27.13	27.13	27.04	27.1	35607.0
2011-10-25 09:30:00	MSFT	Stock	27.1	27.23	27.06	27.13	6644119.0
2011-10-25 10:00:00	MSFT	Stock	27.13	27.15	27.01	27.04	3992258.0
2011-10-25 10:30:00	MSFT	Stock	27.036	27.11	26.96	27.04	4199057.0
2011-10-25 11:00:00	MSFT	Stock	27.035	27.07	27.0	27.01	3059235.0
2011-10-25 11:30:00	MSFT	Stock	27.0	27.1	26.99	27.013	2559419.0
2011-10-25 12:00:00	MSFT	Stock	27.01	27.12	26.99	27.06	2370037.0
2011-10-25 12:30:00	MSFT	Stock	27.065	27.08	27.0	27.02	2063471.0
2011-10-25 13:00:00	MSFT	Stock	27.011	27.1	27.01	27.07	1942907.0
2011-10-25 13:30:00	MSFT	Stock	27.07	27.11	27.04	27.065	2298681.0
2011-10-25 14:00:00	MSFT	Stock	27.06	27.06	26.9	26.93	3166380.0
2011-10-25 14:30:00	MSFT	Stock	26.92	26.99	26.88	26.99	2789908.0
2011-10-25 15:00:00	MSFT	Stock	26.99	27.05	26.93	26.945	2970176.0

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

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