PREVIEW / stock_30min / 2010-07-07

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-07-07.parquet
  size:    1.4 MB
  rows:    77,105
  symbols: 3,459

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-07 05:30:00	AAPL	Stock	8.85	8.8661	8.85	8.8661	5600.0
2010-07-07 06:00:00	AAPL	Stock	8.8661	8.8661	8.8661	8.8661	5600.0
2010-07-07 06:30:00	AAPL	Stock	8.8661	8.8796	8.8661	8.8796	11200.0
2010-07-07 07:00:00	AAPL	Stock	8.8761	8.8893	8.8696	8.8886	180880.0
2010-07-07 07:30:00	AAPL	Stock	8.89	8.8929	8.8829	8.8911	19628.0
2010-07-07 08:00:00	AAPL	Stock	8.895	8.895	8.8629	8.875	550760.0
2010-07-07 08:30:00	AAPL	Stock	8.875	8.8975	8.8586	8.8811	1595776.0
2010-07-07 09:00:00	AAPL	Stock	8.8889	8.9529	8.8839	8.9454	2147040.0
2010-07-07 09:30:00	AAPL	Stock	8.9461	8.9879	8.9196	8.9625	84842520.0
2010-07-07 10:00:00	AAPL	Stock	8.9632	9.0286	8.9611	8.995	71777832.0
2010-07-07 10:30:00	AAPL	Stock	8.9964	9.0389	8.9907	9.0278	49347536.0
2010-07-07 11:00:00	AAPL	Stock	9.0268	9.0543	9.0179	9.052	49672420.0
2010-07-07 11:30:00	AAPL	Stock	9.052	9.0661	9.0286	9.0349	39366656.0
2010-07-07 12:00:00	AAPL	Stock	9.0343	9.0607	9.0329	9.0607	21805756.0
2010-07-07 12:30:00	AAPL	Stock	9.0593	9.0882	9.0593	9.0732	31297392.0
2010-07-07 13:00:00	AAPL	Stock	9.0732	9.1168	9.065	9.1152	33241712.0
2010-07-07 13:30:00	AAPL	Stock	9.1143	9.1339	9.0939	9.1157	34048252.0
2010-07-07 14:00:00	AAPL	Stock	9.1161	9.125	9.1079	9.1143	31216248.0
2010-07-07 14:30:00	AAPL	Stock	9.1143	9.1396	9.1007	9.1396	33608736.0
2010-07-07 15:00:00	AAPL	Stock	9.1386	9.1693	9.1195	9.1689	39995368.0
2010-07-07 15:30:00	AAPL	Stock	9.1675	9.2418	9.1586	9.2418	105502684.0
2010-07-07 16:00:00	AAPL	Stock	9.2386	9.2675	8.946	9.2471	13928040.0
2010-07-07 16:30:00	AAPL	Stock	9.2457	9.2536	9.1693	9.2482	3754324.0
2010-07-07 17:00:00	AAPL	Stock	9.2482	9.2554	9.1279	9.25	555604.0
2010-07-07 17:30:00	AAPL	Stock	9.25	9.2561	9.25	9.255	150304.0
2010-07-07 18:00:00	AAPL	Stock	9.255	9.2571	9.2382	9.2504	473900.0
2010-07-07 18:30:00	AAPL	Stock	9.2532	9.2536	9.2468	9.2496	184660.0
2010-07-07 19:00:00	AAPL	Stock	9.2486	9.2496	9.2411	9.2482	303856.0
2010-07-07 19:30:00	AAPL	Stock	9.2496	9.2536	9.2464	9.2536	295036.0
2010-07-07 07:30:00	MSFT	Stock	23.85	23.85	23.81	23.81	5500.0
2010-07-07 08:00:00	MSFT	Stock	23.84	23.9	23.82	23.9	13232.0
2010-07-07 08:30:00	MSFT	Stock	23.88	23.95	23.88	23.95	7928.0
2010-07-07 09:00:00	MSFT	Stock	23.95	23.95	23.77	23.81	74963.0
2010-07-07 09:30:00	MSFT	Stock	23.82	23.86	23.61	23.74	9912427.0
2010-07-07 10:00:00	MSFT	Stock	23.74	23.91	23.7	23.81	7333164.0
2010-07-07 10:30:00	MSFT	Stock	23.81	24.13	23.79	24.092	8021796.0
2010-07-07 11:00:00	MSFT	Stock	24.09	24.1	23.95	24.03	4949219.0
2010-07-07 11:30:00	MSFT	Stock	24.03	24.12	23.95	24.0	4436001.0
2010-07-07 12:00:00	MSFT	Stock	24.0	24.04	23.925	23.99	2990808.0
2010-07-07 12:30:00	MSFT	Stock	23.985	24.02	23.94	23.951	3030547.0
2010-07-07 13:00:00	MSFT	Stock	23.95	24.12	23.92	24.09	3185008.0
2010-07-07 13:30:00	MSFT	Stock	24.09	24.14	24.05	24.07	2940111.0
2010-07-07 14:00:00	MSFT	Stock	24.07	24.1	23.96	23.961	3344383.0
2010-07-07 14:30:00	MSFT	Stock	23.961	24.07	23.91	24.07	3617288.0
2010-07-07 15:00:00	MSFT	Stock	24.06	24.15	24.0	24.09	4540146.0
2010-07-07 15:30:00	MSFT	Stock	24.09	24.31	24.085	24.31	14808569.0
2010-07-07 16:00:00	MSFT	Stock	24.29	24.35	23.985	24.33	2671515.0
2010-07-07 16:30:00	MSFT	Stock	24.33	24.39	24.002	24.33	627888.0
2010-07-07 17:00:00	MSFT	Stock	23.82	24.35	23.82	24.33	35542.0
2010-07-07 17:30:00	MSFT	Stock	24.3	24.36	24.3	24.36	4159.0

> showing 50 of 77,105 rows — these rows as CSV

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