PREVIEW / stock_30min / 2011-07-01

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-07-01.parquet
  size:    1.4 MB
  rows:    75,927
  symbols: 3,511

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-07-01 07:00:00	AAPL	Stock	11.975	12.0357	11.975	11.9821	86800.0
2011-07-01 07:30:00	AAPL	Stock	11.9839	11.9893	11.9821	11.9821	68740.0
2011-07-01 08:00:00	AAPL	Stock	11.9882	11.9882	11.9646	11.9804	205940.0
2011-07-01 08:30:00	AAPL	Stock	11.9804	11.9882	11.9768	11.9857	435008.0
2011-07-01 09:00:00	AAPL	Stock	11.9821	12.0	11.9736	11.9946	1814904.0
2011-07-01 09:30:00	AAPL	Stock	11.9943	12.0039	11.9357	11.9911	37724904.0
2011-07-01 10:00:00	AAPL	Stock	11.9925	12.0611	11.9889	12.0321	49880208.0
2011-07-01 10:30:00	AAPL	Stock	12.0337	12.0436	12.0186	12.0307	20596912.0
2011-07-01 11:00:00	AAPL	Stock	12.0294	12.0682	12.0279	12.065	25127144.0
2011-07-01 11:30:00	AAPL	Stock	12.065	12.1582	12.065	12.1336	56085764.0
2011-07-01 12:00:00	AAPL	Stock	12.1336	12.185	12.127	12.1748	28625492.0
2011-07-01 12:30:00	AAPL	Stock	12.175	12.1757	12.1546	12.17	14231252.0
2011-07-01 13:00:00	AAPL	Stock	12.1693	12.1857	12.1664	12.1771	18931136.0
2011-07-01 13:30:00	AAPL	Stock	12.1779	12.2657	12.1746	12.2518	33658128.0
2011-07-01 14:00:00	AAPL	Stock	12.2511	12.2554	12.2014	12.24	35467684.0
2011-07-01 14:30:00	AAPL	Stock	12.2389	12.2564	12.2321	12.2539	18747960.0
2011-07-01 15:00:00	AAPL	Stock	12.2554	12.2643	12.2246	12.225	29365700.0
2011-07-01 15:30:00	AAPL	Stock	12.2258	12.2679	12.2161	12.2643	49431816.0
2011-07-01 16:00:00	AAPL	Stock	12.2582	12.2679	12.1071	12.2518	11296124.0
2011-07-01 16:30:00	AAPL	Stock	12.2518	12.2536	12.23	12.2303	177800.0
2011-07-01 17:00:00	AAPL	Stock	12.2471	12.2482	12.2321	12.2482	119280.0
2011-07-01 17:30:00	AAPL	Stock	12.2414	12.2496	12.2379	12.2496	102424.0
2011-07-01 18:00:00	AAPL	Stock	12.2593	12.2593	12.2436	12.2496	663124.0
2011-07-01 18:30:00	AAPL	Stock	12.2496	12.2496	12.2414	12.2471	31220.0
2011-07-01 19:00:00	AAPL	Stock	12.25	12.2536	12.25	12.25	32760.0
2011-07-01 19:30:00	AAPL	Stock	12.2482	12.2518	12.2482	12.2518	41440.0
2011-07-01 08:00:00	MSFT	Stock	25.91	26.03	25.91	26.0	59616.0
2011-07-01 08:30:00	MSFT	Stock	25.99	26.0	25.93	26.0	6726.0
2011-07-01 09:00:00	MSFT	Stock	25.93	25.95	25.92	25.93	18350.0
2011-07-01 09:30:00	MSFT	Stock	25.94	25.96	25.84	25.94	2988216.0
2011-07-01 10:00:00	MSFT	Stock	25.95	26.12	25.95	26.065	7711483.0
2011-07-01 10:30:00	MSFT	Stock	26.07	26.11	26.01	26.055	3702132.0
2011-07-01 11:00:00	MSFT	Stock	26.05	26.105	26.01	26.055	3618530.0
2011-07-01 11:30:00	MSFT	Stock	26.05	26.09	26.04	26.075	2108537.0
2011-07-01 12:00:00	MSFT	Stock	26.075	26.1	26.05	26.07	1545816.0
2011-07-01 12:30:00	MSFT	Stock	26.07	26.08	26.05	26.07	1156238.0
2011-07-01 13:00:00	MSFT	Stock	26.071	26.145	26.05	26.14	1811969.0
2011-07-01 13:30:00	MSFT	Stock	26.13	26.15	26.11	26.135	2300260.0
2011-07-01 14:00:00	MSFT	Stock	26.13	26.17	26.07	26.09	2727009.0
2011-07-01 14:30:00	MSFT	Stock	26.09	26.13	26.06	26.11	2345776.0
2011-07-01 15:00:00	MSFT	Stock	26.11	26.13	26.03	26.065	3459193.0
2011-07-01 15:30:00	MSFT	Stock	26.07	26.1	26.01	26.06	8233231.0
2011-07-01 16:00:00	MSFT	Stock	26.065	26.08	25.95	26.02	4325291.0
2011-07-01 16:30:00	MSFT	Stock	26.0	26.064	25.98	25.99	1526768.0
2011-07-01 18:00:00	MSFT	Stock	26.02	26.02	26.02	26.02	3500.0
2011-07-01 18:30:00	MSFT	Stock	25.97	25.97	25.97	25.97	800.0
2011-07-01 19:00:00	MSFT	Stock	25.96	25.97	25.96	25.97	268.0
2011-07-01 19:30:00	MSFT	Stock	26.0	26.12	25.96	26.11	8215.0
2011-07-01 07:30:00	NVDA	Stock	0.3988	0.3988	0.3988	0.3988	4000.0
2011-07-01 08:00:00	NVDA	Stock	0.3984	0.3984	0.3984	0.3984	468000.0

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

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