PREVIEW / stock_30min / 2010-04-22

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-04-22.parquet
  size:    1.4 MB
  rows:    75,054
  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-04-22 04:00:00	AAPL	Stock	9.2689	9.2732	9.2504	9.2625	77140.0
2010-04-22 04:30:00	AAPL	Stock	9.2625	9.265	9.2571	9.2575	110460.0
2010-04-22 05:00:00	AAPL	Stock	9.2575	9.2593	9.2464	9.2464	84000.0
2010-04-22 05:30:00	AAPL	Stock	9.2236	9.2236	9.2146	9.2146	19600.0
2010-04-22 06:00:00	AAPL	Stock	9.2318	9.2318	9.2071	9.2211	26600.0
2010-04-22 06:30:00	AAPL	Stock	9.2075	9.2143	9.2075	9.2143	56000.0
2010-04-22 07:00:00	AAPL	Stock	9.2211	9.2214	9.2164	9.2179	50400.0
2010-04-22 07:30:00	AAPL	Stock	9.2121	9.2321	9.2107	9.2214	320180.0
2010-04-22 08:00:00	AAPL	Stock	9.2196	9.2432	9.2129	9.2286	1246168.0
2010-04-22 08:30:00	AAPL	Stock	9.2304	9.2325	9.2232	9.2264	511140.0
2010-04-22 09:00:00	AAPL	Stock	9.2282	9.2282	9.2054	9.2214	1629684.0
2010-04-22 09:30:00	AAPL	Stock	9.2214	9.2339	9.15	9.2054	98111104.0
2010-04-22 10:00:00	AAPL	Stock	9.2054	9.2214	9.1814	9.2193	52118528.0
2010-04-22 10:30:00	AAPL	Stock	9.22	9.2529	9.2014	9.2239	50236984.0
2010-04-22 11:00:00	AAPL	Stock	9.2236	9.2289	9.2039	9.2161	24809456.0
2010-04-22 11:30:00	AAPL	Stock	9.2161	9.2298	9.2064	9.2164	20004292.0
2010-04-22 12:00:00	AAPL	Stock	9.2179	9.2457	9.2086	9.2446	20863696.0
2010-04-22 12:30:00	AAPL	Stock	9.2443	9.2493	9.2232	9.2393	20105260.0
2010-04-22 13:00:00	AAPL	Stock	9.2393	9.2804	9.2352	9.2725	36546356.0
2010-04-22 13:30:00	AAPL	Stock	9.2725	9.3871	9.27	9.385	84279412.0
2010-04-22 14:00:00	AAPL	Stock	9.3864	9.4475	9.3807	9.4364	93667868.0
2010-04-22 14:30:00	AAPL	Stock	9.4361	9.4811	9.4286	9.4704	74819108.0
2010-04-22 15:00:00	AAPL	Stock	9.4707	9.5268	9.4686	9.4943	98544208.0
2010-04-22 15:30:00	AAPL	Stock	9.4936	9.525	9.4643	9.5118	96163256.0
2010-04-22 16:00:00	AAPL	Stock	9.5118	9.5179	9.2116	9.4946	10439072.0
2010-04-22 16:30:00	AAPL	Stock	9.4857	9.4946	9.4076	9.4825	677376.0
2010-04-22 17:00:00	AAPL	Stock	9.4846	9.4857	9.2257	9.4821	192192.0
2010-04-22 17:30:00	AAPL	Stock	9.4839	9.5125	9.4839	9.5082	697340.0
2010-04-22 18:00:00	AAPL	Stock	9.5018	9.5318	9.4989	9.5089	766360.0
2010-04-22 18:30:00	AAPL	Stock	9.5171	9.5239	9.5143	9.5143	120568.0
2010-04-22 19:00:00	AAPL	Stock	9.5146	9.5179	9.5114	9.5114	180096.0
2010-04-22 19:30:00	AAPL	Stock	9.5171	9.5179	9.5071	9.5071	255500.0
2010-04-22 07:00:00	MSFT	Stock	31.22	31.22	31.16	31.22	1815.0
2010-04-22 07:30:00	MSFT	Stock	31.23	31.23	31.17	31.23	6100.0
2010-04-22 08:00:00	MSFT	Stock	31.2	31.286	31.18	31.2	43083.0
2010-04-22 08:30:00	MSFT	Stock	31.2	31.25	31.11	31.14	58118.0
2010-04-22 09:00:00	MSFT	Stock	31.13	31.24	31.04	31.05	136393.0
2010-04-22 09:30:00	MSFT	Stock	31.05	31.12	30.9	31.08	6207162.0
2010-04-22 10:00:00	MSFT	Stock	31.08	31.25	31.03	31.22	5475014.0
2010-04-22 10:30:00	MSFT	Stock	31.22	31.25	31.07	31.2	4216718.0
2010-04-22 11:00:00	MSFT	Stock	31.19	31.23	31.02	31.07	3954450.0
2010-04-22 11:30:00	MSFT	Stock	31.08	31.08	30.95	30.99	3462283.0
2010-04-22 12:00:00	MSFT	Stock	31.0	31.06	30.95	31.0	2680781.0
2010-04-22 12:30:00	MSFT	Stock	31.0	31.12	30.99	31.1	3094732.0
2010-04-22 13:00:00	MSFT	Stock	31.09	31.28	31.08	31.239	4148023.0
2010-04-22 13:30:00	MSFT	Stock	31.236	31.34	31.22	31.331	3147584.0
2010-04-22 14:00:00	MSFT	Stock	31.34	31.37	31.27	31.36	4181018.0
2010-04-22 14:30:00	MSFT	Stock	31.361	31.408	31.23	31.27	6213475.0
2010-04-22 15:00:00	MSFT	Stock	31.268	31.48	31.23	31.45	7081310.0
2010-04-22 15:30:00	MSFT	Stock	31.445	31.53	31.37	31.37	14444106.0

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

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