PREVIEW / stock_30min / 2010-07-09

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-07-09.parquet
  size:    1.3 MB
  rows:    73,716
  symbols: 3,456

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-09 05:00:00	AAPL	Stock	9.2321	9.2321	9.2321	9.2321	2800.0
2010-07-09 07:00:00	AAPL	Stock	9.2282	9.25	9.2282	9.2357	72324.0
2010-07-09 07:30:00	AAPL	Stock	9.2321	9.2357	9.1786	9.1875	173096.0
2010-07-09 08:00:00	AAPL	Stock	9.2032	9.2332	9.115	9.1375	1596448.0
2010-07-09 08:30:00	AAPL	Stock	9.1357	9.1536	9.1161	9.1536	657356.0
2010-07-09 09:00:00	AAPL	Stock	9.1539	9.1821	9.1404	9.1736	1027544.0
2010-07-09 09:30:00	AAPL	Stock	9.1743	9.2282	9.1129	9.1814	69759872.0
2010-07-09 10:00:00	AAPL	Stock	9.1804	9.2286	9.1721	9.1969	47188036.0
2010-07-09 10:30:00	AAPL	Stock	9.1964	9.1979	9.1607	9.1686	30187920.0
2010-07-09 11:00:00	AAPL	Stock	9.1686	9.19	9.1593	9.1839	23036468.0
2010-07-09 11:30:00	AAPL	Stock	9.1836	9.2286	9.1821	9.195	45707676.0
2010-07-09 12:00:00	AAPL	Stock	9.1975	9.2232	9.1829	9.215	16998240.0
2010-07-09 12:30:00	AAPL	Stock	9.2157	9.2162	9.1757	9.1964	19893720.0
2010-07-09 13:00:00	AAPL	Stock	9.1957	9.2139	9.1875	9.1898	11270980.0
2010-07-09 13:30:00	AAPL	Stock	9.1893	9.2114	9.1857	9.2032	11995900.0
2010-07-09 14:00:00	AAPL	Stock	9.2036	9.2079	9.1832	9.1918	12868156.0
2010-07-09 14:30:00	AAPL	Stock	9.1926	9.2486	9.1871	9.2396	25431224.0
2010-07-09 15:00:00	AAPL	Stock	9.2396	9.2821	9.2311	9.2524	50938160.0
2010-07-09 15:30:00	AAPL	Stock	9.25	9.2796	9.2339	9.275	56108808.0
2010-07-09 16:00:00	AAPL	Stock	9.2743	9.2796	9.211	9.2746	5413184.0
2010-07-09 16:30:00	AAPL	Stock	9.2239	9.2761	9.1838	9.2729	1279684.0
2010-07-09 17:00:00	AAPL	Stock	9.2732	9.275	9.2696	9.2696	180992.0
2010-07-09 17:30:00	AAPL	Stock	9.2696	9.2696	9.2679	9.2679	14000.0
2010-07-09 18:00:00	AAPL	Stock	9.2721	9.2775	9.2721	9.2775	247660.0
2010-07-09 18:30:00	AAPL	Stock	9.2732	9.2818	9.2732	9.2786	64400.0
2010-07-09 19:00:00	AAPL	Stock	9.2786	9.2804	9.2771	9.2775	58800.0
2010-07-09 19:30:00	AAPL	Stock	9.275	9.2821	9.2739	9.2811	140420.0
2010-07-09 07:00:00	MSFT	Stock	24.5	24.5	24.5	24.5	2800.0
2010-07-09 07:30:00	MSFT	Stock	24.51	24.51	24.5	24.5	3440.0
2010-07-09 08:00:00	MSFT	Stock	24.5	24.53	24.41	24.41	3960.0
2010-07-09 08:30:00	MSFT	Stock	24.41	24.41	24.35	24.36	7555.0
2010-07-09 09:00:00	MSFT	Stock	24.37	24.4	24.29	24.32	20058.0
2010-07-09 09:30:00	MSFT	Stock	24.33	24.41	24.23	24.31	4396545.0
2010-07-09 10:00:00	MSFT	Stock	24.307	24.33	24.17	24.199	4812654.0
2010-07-09 10:30:00	MSFT	Stock	24.2	24.3	24.17	24.25	3487244.0
2010-07-09 11:00:00	MSFT	Stock	24.26	24.28	24.19	24.28	3584929.0
2010-07-09 11:30:00	MSFT	Stock	24.28	24.32	24.23	24.24	2674187.0
2010-07-09 12:00:00	MSFT	Stock	24.24	24.28	24.22	24.27	1841277.0
2010-07-09 12:30:00	MSFT	Stock	24.27	24.279	24.2	24.21	2037830.0
2010-07-09 13:00:00	MSFT	Stock	24.21	24.29	24.2	24.2	2824093.0
2010-07-09 13:30:00	MSFT	Stock	24.2	24.24	24.15	24.21	3208448.0
2010-07-09 14:00:00	MSFT	Stock	24.22	24.22	24.15	24.19	2371819.0
2010-07-09 14:30:00	MSFT	Stock	24.19	24.26	24.16	24.21	4408391.0
2010-07-09 15:00:00	MSFT	Stock	24.215	24.25	24.15	24.16	4889270.0
2010-07-09 15:30:00	MSFT	Stock	24.165	24.29	24.16	24.27	9006646.0
2010-07-09 16:00:00	MSFT	Stock	24.27	24.32	24.233	24.27	2294092.0
2010-07-09 16:30:00	MSFT	Stock	24.27	24.28	24.216	24.26	181601.0
2010-07-09 17:00:00	MSFT	Stock	24.18	24.27	24.18	24.27	1964.0
2010-07-09 17:30:00	MSFT	Stock	24.27	24.27	24.26	24.26	1639.0
2010-07-09 18:00:00	MSFT	Stock	24.27	24.27	24.26	24.27	4231.0

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

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