PREVIEW / stock_30min / 2010-09-03

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-09-03.parquet
  size:    1.3 MB
  rows:    74,414
  symbols: 3,473

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-09-03 05:00:00	AAPL	Stock	9.0079	9.0079	9.0079	9.0079	2800.0
2010-09-03 07:00:00	AAPL	Stock	8.9754	8.9911	8.9554	8.9911	59780.0
2010-09-03 07:30:00	AAPL	Stock	8.9811	9.0	8.9761	8.995	131600.0
2010-09-03 08:00:00	AAPL	Stock	8.9929	9.005	8.9829	8.9829	766668.0
2010-09-03 08:30:00	AAPL	Stock	8.9829	9.1304	8.9829	9.125	9675456.0
2010-09-03 09:00:00	AAPL	Stock	9.125	9.1268	9.1071	9.1129	3449236.0
2010-09-03 09:30:00	AAPL	Stock	9.11	9.1929	9.0893	9.1811	104539232.0
2010-09-03 10:00:00	AAPL	Stock	9.1777	9.1857	9.1071	9.1118	59889732.0
2010-09-03 10:30:00	AAPL	Stock	9.1139	9.1221	9.0954	9.1138	35721700.0
2010-09-03 11:00:00	AAPL	Stock	9.1129	9.1389	9.1004	9.1368	22711668.0
2010-09-03 11:30:00	AAPL	Stock	9.1371	9.1757	9.1293	9.1711	26662272.0
2010-09-03 12:00:00	AAPL	Stock	9.1704	9.1786	9.1611	9.1657	18718392.0
2010-09-03 12:30:00	AAPL	Stock	9.1661	9.1946	9.1651	9.19	25180400.0
2010-09-03 13:00:00	AAPL	Stock	9.1893	9.205	9.1893	9.1978	23308096.0
2010-09-03 13:30:00	AAPL	Stock	9.1979	9.2279	9.1979	9.2225	28494620.0
2010-09-03 14:00:00	AAPL	Stock	9.2221	9.2282	9.2104	9.2243	22309252.0
2010-09-03 14:30:00	AAPL	Stock	9.2242	9.2354	9.1996	9.2031	25397512.0
2010-09-03 15:00:00	AAPL	Stock	9.2036	9.225	9.1968	9.2229	22741936.0
2010-09-03 15:30:00	AAPL	Stock	9.2229	9.2421	9.205	9.2418	49067480.0
2010-09-03 16:00:00	AAPL	Stock	9.2414	9.2489	9.0187	9.2386	37144884.0
2010-09-03 16:30:00	AAPL	Stock	9.2379	9.2429	9.2201	9.2393	2122036.0
2010-09-03 17:00:00	AAPL	Stock	9.2375	9.2418	9.2321	9.2389	768852.0
2010-09-03 17:30:00	AAPL	Stock	9.2357	9.2357	9.2321	9.2339	50792.0
2010-09-03 18:00:00	AAPL	Stock	9.2354	9.2418	9.2321	9.2339	321104.0
2010-09-03 18:30:00	AAPL	Stock	9.235	9.235	9.225	9.2286	136920.0
2010-09-03 19:00:00	AAPL	Stock	9.2268	9.2286	9.2264	9.2286	45612.0
2010-09-03 19:30:00	AAPL	Stock	9.2304	9.2321	9.2286	9.23	63140.0
2010-09-03 20:00:00	AAPL	Stock	9.1421	9.1421	9.1421	9.1421	16800.0
2010-09-03 06:00:00	MSFT	Stock	23.97	23.97	23.97	23.97	1000.0
2010-09-03 06:30:00	MSFT	Stock	24.04	24.04	24.04	24.04	4000.0
2010-09-03 07:00:00	MSFT	Stock	24.06	24.06	23.98	23.98	1400.0
2010-09-03 07:30:00	MSFT	Stock	24.02	24.02	23.91	23.91	6700.0
2010-09-03 08:00:00	MSFT	Stock	23.97	23.97	23.9	23.94	5650.0
2010-09-03 08:30:00	MSFT	Stock	23.95	24.38	23.95	24.23	143342.0
2010-09-03 09:00:00	MSFT	Stock	24.23	24.3	24.15	24.19	277875.0
2010-09-03 09:30:00	MSFT	Stock	24.22	24.45	24.2	24.41	7933746.0
2010-09-03 10:00:00	MSFT	Stock	24.4	24.4	24.24	24.29	6672488.0
2010-09-03 10:30:00	MSFT	Stock	24.3	24.33	24.28	24.325	4735460.0
2010-09-03 11:00:00	MSFT	Stock	24.325	24.34	24.29	24.31	3657944.0
2010-09-03 11:30:00	MSFT	Stock	24.31	24.35	24.26	24.285	4309141.0
2010-09-03 12:00:00	MSFT	Stock	24.285	24.29	24.24	24.25	2262939.0
2010-09-03 12:30:00	MSFT	Stock	24.241	24.3	24.24	24.3	4135484.0
2010-09-03 13:00:00	MSFT	Stock	24.3	24.31	24.28	24.3	2291777.0
2010-09-03 13:30:00	MSFT	Stock	24.3	24.31	24.28	24.299	2766593.0
2010-09-03 14:00:00	MSFT	Stock	24.295	24.34	24.29	24.32	3137172.0
2010-09-03 14:30:00	MSFT	Stock	24.32	24.32	24.25	24.27	3548760.0
2010-09-03 15:00:00	MSFT	Stock	24.27	24.3	24.24	24.29	4022359.0
2010-09-03 15:30:00	MSFT	Stock	24.289	24.31	24.27	24.305	8565544.0
2010-09-03 16:00:00	MSFT	Stock	24.305	24.33	24.259	24.32	4660936.0
2010-09-03 16:30:00	MSFT	Stock	24.33	24.33	24.28	24.33	566627.0

> showing 50 of 74,414 rows — these rows as CSV

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