PREVIEW / stock_30min / 2010-11-24

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-11-24.parquet
  size:    1.4 MB
  rows:    75,079
  symbols: 3,510

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-11-24 04:00:00	AAPL	Stock	11.025	11.0357	10.9475	10.9714	50400.0
2010-11-24 04:30:00	AAPL	Stock	10.9643	10.9643	10.9643	10.9643	5600.0
2010-11-24 05:00:00	AAPL	Stock	10.9643	10.975	10.9643	10.975	8400.0
2010-11-24 05:30:00	AAPL	Stock	10.9882	10.9893	10.9807	10.9893	22400.0
2010-11-24 06:00:00	AAPL	Stock	11.0036	11.0286	11.0036	11.0286	22400.0
2010-11-24 06:30:00	AAPL	Stock	11.0429	11.0461	11.0261	11.0261	67200.0
2010-11-24 07:00:00	AAPL	Stock	11.025	11.05	11.025	11.0496	233548.0
2010-11-24 07:30:00	AAPL	Stock	11.0479	11.075	11.0479	11.0718	322700.0
2010-11-24 08:00:00	AAPL	Stock	11.0746	11.1214	11.0671	11.1196	2486848.0
2010-11-24 08:30:00	AAPL	Stock	11.1196	11.1804	11.1014	11.1504	4425568.0
2010-11-24 09:00:00	AAPL	Stock	11.1521	11.1579	11.1346	11.1468	1600340.0
2010-11-24 09:30:00	AAPL	Stock	11.1461	11.1732	11.1339	11.1568	70018928.0
2010-11-24 10:00:00	AAPL	Stock	11.1564	11.2493	11.145	11.2471	71677900.0
2010-11-24 10:30:00	AAPL	Stock	11.245	11.25	11.2264	11.2429	38587192.0
2010-11-24 11:00:00	AAPL	Stock	11.2441	11.2464	11.2221	11.2389	24440248.0
2010-11-24 11:30:00	AAPL	Stock	11.2385	11.2446	11.2232	11.2364	17065636.0
2010-11-24 12:00:00	AAPL	Stock	11.2346	11.2429	11.2303	11.2368	13723976.0
2010-11-24 12:30:00	AAPL	Stock	11.2382	11.2446	11.2314	11.2418	13417936.0
2010-11-24 13:00:00	AAPL	Stock	11.2418	11.25	11.2386	11.2479	16519804.0
2010-11-24 13:30:00	AAPL	Stock	11.2479	11.2493	11.2407	11.2479	13205248.0
2010-11-24 14:00:00	AAPL	Stock	11.2475	11.2643	11.2321	11.2486	29371356.0
2010-11-24 14:30:00	AAPL	Stock	11.2496	11.2571	11.2436	11.2507	12930820.0
2010-11-24 15:00:00	AAPL	Stock	11.2504	11.2589	11.2457	11.2507	15230012.0
2010-11-24 15:30:00	AAPL	Stock	11.2507	11.2529	11.2321	11.2421	45457888.0
2010-11-24 16:00:00	AAPL	Stock	11.2421	11.2494	11.1467	11.2494	17558912.0
2010-11-24 16:30:00	AAPL	Stock	11.2429	11.2517	11.1518	11.2386	330204.0
2010-11-24 17:00:00	AAPL	Stock	11.2414	11.2471	11.2357	11.2429	732788.0
2010-11-24 17:30:00	AAPL	Stock	11.2429	11.2429	11.2379	11.2429	67116.0
2010-11-24 18:00:00	AAPL	Stock	11.2429	11.2429	11.2414	11.2429	143220.0
2010-11-24 18:30:00	AAPL	Stock	11.2446	11.2446	11.2379	11.2382	84140.0
2010-11-24 19:00:00	AAPL	Stock	11.2411	11.2443	11.2379	11.2379	59668.0
2010-11-24 19:30:00	AAPL	Stock	11.2429	11.25	11.2396	11.25	290472.0
2010-11-24 04:30:00	MSFT	Stock	25.05	25.05	25.05	25.05	100.0
2010-11-24 05:00:00	MSFT	Stock	25.05	25.05	25.05	25.05	100.0
2010-11-24 06:00:00	MSFT	Stock	25.05	25.05	25.05	25.05	150.0
2010-11-24 06:30:00	MSFT	Stock	25.17	25.17	25.11	25.11	200.0
2010-11-24 07:00:00	MSFT	Stock	25.11	25.18	25.11	25.18	1250.0
2010-11-24 07:30:00	MSFT	Stock	25.18	25.18	25.18	25.18	200.0
2010-11-24 08:00:00	MSFT	Stock	25.18	25.25	25.18	25.24	14809.0
2010-11-24 08:30:00	MSFT	Stock	25.24	25.3	25.19	25.23	49145.0
2010-11-24 09:00:00	MSFT	Stock	25.23	25.3	25.16	25.16	162920.0
2010-11-24 09:30:00	MSFT	Stock	25.2	25.35	25.16	25.215	8482091.0
2010-11-24 10:00:00	MSFT	Stock	25.21	25.4	25.175	25.371	6097283.0
2010-11-24 10:30:00	MSFT	Stock	25.375	25.41	25.33	25.389	3833864.0
2010-11-24 11:00:00	MSFT	Stock	25.385	25.43	25.35	25.417	3920759.0
2010-11-24 11:30:00	MSFT	Stock	25.42	25.44	25.395	25.41	4060728.0
2010-11-24 12:00:00	MSFT	Stock	25.405	25.45	25.4	25.43	2044841.0
2010-11-24 12:30:00	MSFT	Stock	25.42	25.45	25.39	25.41	1928579.0
2010-11-24 13:00:00	MSFT	Stock	25.4	25.44	25.4	25.421	3444162.0
2010-11-24 13:30:00	MSFT	Stock	25.43	25.43	25.35	25.38	2104987.0

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

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