PREVIEW / stock_30min / 2011-11-02

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-11-02.parquet
  size:    1.4 MB
  rows:    75,002
  symbols: 3,495

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-11-02 04:00:00	AAPL	Stock	14.2686	14.315	14.2686	14.315	28000.0
2011-11-02 04:30:00	AAPL	Stock	14.2875	14.3125	14.2875	14.3125	16800.0
2011-11-02 05:00:00	AAPL	Stock	14.3125	14.3125	14.2857	14.2857	16800.0
2011-11-02 05:30:00	AAPL	Stock	14.2732	14.2732	14.2143	14.2286	39200.0
2011-11-02 06:00:00	AAPL	Stock	14.2214	14.2286	14.2214	14.2286	14000.0
2011-11-02 06:30:00	AAPL	Stock	14.225	14.225	14.225	14.225	2800.0
2011-11-02 07:00:00	AAPL	Stock	14.2286	14.2679	14.2286	14.2679	96040.0
2011-11-02 07:30:00	AAPL	Stock	14.2679	14.2857	14.25	14.2679	95760.0
2011-11-02 08:00:00	AAPL	Stock	14.25	14.2768	14.2325	14.2461	862064.0
2011-11-02 08:30:00	AAPL	Stock	14.2464	14.2607	14.2396	14.2518	574028.0
2011-11-02 09:00:00	AAPL	Stock	14.2536	14.3164	14.2536	14.2884	1948520.0
2011-11-02 09:30:00	AAPL	Stock	14.2929	14.3014	14.1889	14.2086	44526132.0
2011-11-02 10:00:00	AAPL	Stock	14.21	14.2286	14.1589	14.1825	29759660.0
2011-11-02 10:30:00	AAPL	Stock	14.1829	14.2368	14.1393	14.2218	30965228.0
2011-11-02 11:00:00	AAPL	Stock	14.2229	14.2332	14.1954	14.2034	17829140.0
2011-11-02 11:30:00	AAPL	Stock	14.2082	14.2125	14.1832	14.1975	10915884.0
2011-11-02 12:00:00	AAPL	Stock	14.1989	14.215	14.1825	14.2043	10774848.0
2011-11-02 12:30:00	AAPL	Stock	14.2021	14.2225	14.175	14.1814	18779236.0
2011-11-02 13:00:00	AAPL	Stock	14.18	14.1893	14.1429	14.1607	19353488.0
2011-11-02 13:30:00	AAPL	Stock	14.1607	14.1786	14.1268	14.1411	15553188.0
2011-11-02 14:00:00	AAPL	Stock	14.1396	14.1544	14.1111	14.1368	22095808.0
2011-11-02 14:30:00	AAPL	Stock	14.135	14.2018	14.1289	14.1921	20322540.0
2011-11-02 15:00:00	AAPL	Stock	14.1929	14.2204	14.1693	14.1966	24674356.0
2011-11-02 15:30:00	AAPL	Stock	14.1961	14.2111	14.1511	14.1893	33219256.0
2011-11-02 16:00:00	AAPL	Stock	14.1893	14.2418	14.1611	14.2357	19583648.0
2011-11-02 16:30:00	AAPL	Stock	14.2329	14.2468	14.1932	14.2461	2442188.0
2011-11-02 17:00:00	AAPL	Stock	14.2421	14.2589	14.2371	14.2589	631904.0
2011-11-02 17:30:00	AAPL	Stock	14.2543	14.2589	14.2321	14.25	279524.0
2011-11-02 18:00:00	AAPL	Stock	14.2496	14.25	14.2325	14.2325	130144.0
2011-11-02 18:30:00	AAPL	Stock	14.2339	14.2339	14.1886	14.1964	369264.0
2011-11-02 19:00:00	AAPL	Stock	14.1896	14.1968	14.1896	14.1964	41076.0
2011-11-02 19:30:00	AAPL	Stock	14.2036	14.2054	14.1746	14.1786	484288.0
2011-11-02 08:00:00	MSFT	Stock	26.1	26.2	26.1	26.2	19680.0
2011-11-02 08:30:00	MSFT	Stock	26.19	26.2	26.17	26.2	8149.0
2011-11-02 09:00:00	MSFT	Stock	26.18	26.2	26.07	26.08	49798.0
2011-11-02 09:30:00	MSFT	Stock	26.09	26.2	25.94	25.95	4372770.0
2011-11-02 10:00:00	MSFT	Stock	25.95	25.95	25.83	25.91	4177875.0
2011-11-02 10:30:00	MSFT	Stock	25.92	26.09	25.88	26.08	3157590.0
2011-11-02 11:00:00	MSFT	Stock	26.08	26.139	25.99	26.05	2918863.0
2011-11-02 11:30:00	MSFT	Stock	26.045	26.08	26.01	26.06	2796278.0
2011-11-02 12:00:00	MSFT	Stock	26.05	26.059	25.93	25.99	1717603.0
2011-11-02 12:30:00	MSFT	Stock	25.98	26.07	25.92	25.93	2053554.0
2011-11-02 13:00:00	MSFT	Stock	25.94	25.95	25.8	25.8	2763302.0
2011-11-02 13:30:00	MSFT	Stock	25.805	25.83	25.76	25.79	2801462.0
2011-11-02 14:00:00	MSFT	Stock	25.78	25.88	25.7	25.86	4301337.0
2011-11-02 14:30:00	MSFT	Stock	25.86	26.03	25.84	26.0	2884397.0
2011-11-02 15:00:00	MSFT	Stock	26.0	26.13	25.941	26.11	3182351.0
2011-11-02 15:30:00	MSFT	Stock	26.11	26.13	26.01	26.01	9059935.0
2011-11-02 16:00:00	MSFT	Stock	26.02	26.12	25.972	26.01	6002166.0
2011-11-02 16:30:00	MSFT	Stock	26.01	26.11	26.01	26.05	375412.0

> showing 50 of 75,002 rows — these rows as CSV

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