PREVIEW / stock_30min / 2009-04-06

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-04-06.parquet
  size:    1.2 MB
  rows:    69,387
  symbols: 3,303

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
2009-04-06 07:00:00	AAPL	Stock	4.1768	4.1768	4.1768	4.1768	138320.0
2009-04-06 07:30:00	AAPL	Stock	4.1607	4.1607	4.1454	4.1454	103600.0
2009-04-06 08:00:00	AAPL	Stock	4.1454	4.1482	4.1071	4.1161	695912.0
2009-04-06 08:30:00	AAPL	Stock	4.1154	4.1154	4.1068	4.1107	461524.0
2009-04-06 09:00:00	AAPL	Stock	4.1104	4.1143	4.0975	4.105	487312.0
2009-04-06 09:30:00	AAPL	Stock	4.105	4.1193	4.0643	4.0754	80697568.0
2009-04-06 10:00:00	AAPL	Stock	4.0763	4.1029	4.0525	4.0576	55652436.0
2009-04-06 10:30:00	AAPL	Stock	4.0579	4.0764	4.0504	4.06	33658100.0
2009-04-06 11:00:00	AAPL	Stock	4.0596	4.0746	4.0457	4.0661	26526248.0
2009-04-06 11:30:00	AAPL	Stock	4.0661	4.0782	4.0589	4.0754	26985056.0
2009-04-06 12:00:00	AAPL	Stock	4.0754	4.0957	4.0739	4.0871	20298796.0
2009-04-06 12:30:00	AAPL	Stock	4.0868	4.1282	4.0757	4.1279	26414388.0
2009-04-06 13:00:00	AAPL	Stock	4.1286	4.1411	4.1189	4.1311	36358504.0
2009-04-06 13:30:00	AAPL	Stock	4.1318	4.1868	4.1132	4.1704	55811448.0
2009-04-06 14:00:00	AAPL	Stock	4.1707	4.1964	4.1675	4.1946	56474488.0
2009-04-06 14:30:00	AAPL	Stock	4.195	4.2204	4.1696	4.2143	71977556.0
2009-04-06 15:00:00	AAPL	Stock	4.2157	4.2321	4.1911	4.217	67774476.0
2009-04-06 15:30:00	AAPL	Stock	4.2164	4.2411	4.2	4.23	73827040.0
2009-04-06 16:00:00	AAPL	Stock	4.23	4.2357	4.1429	4.2282	14740040.0
2009-04-06 16:30:00	AAPL	Stock	4.2282	4.23	4.1891	4.23	1416688.0
2009-04-06 17:00:00	AAPL	Stock	4.2257	4.2286	4.2257	4.2286	23660.0
2009-04-06 17:30:00	AAPL	Stock	4.2268	4.2286	4.225	4.2286	138936.0
2009-04-06 18:00:00	AAPL	Stock	4.2286	4.2325	4.2257	4.2293	900564.0
2009-04-06 18:30:00	AAPL	Stock	4.2293	4.23	4.225	4.225	155960.0
2009-04-06 19:00:00	AAPL	Stock	4.2236	4.2293	4.2236	4.2282	106596.0
2009-04-06 19:30:00	AAPL	Stock	4.2296	4.2304	4.2254	4.23	137900.0
2009-04-06 07:00:00	MSFT	Stock	18.88	18.88	18.88	18.88	435.0
2009-04-06 07:30:00	MSFT	Stock	18.78	18.78	18.46	18.69	8965.0
2009-04-06 08:00:00	MSFT	Stock	18.63	18.73	18.6	18.64	21102.0
2009-04-06 08:30:00	MSFT	Stock	18.62	18.65	18.54	18.6	39999.0
2009-04-06 09:00:00	MSFT	Stock	18.57	18.6	18.52	18.55	21294.0
2009-04-06 09:30:00	MSFT	Stock	18.56	18.69	18.265	18.38	6185229.0
2009-04-06 10:00:00	MSFT	Stock	18.38	18.51	18.34	18.36	5223836.0
2009-04-06 10:30:00	MSFT	Stock	18.35	18.5	18.33	18.46	2113537.0
2009-04-06 11:00:00	MSFT	Stock	18.46	18.54	18.42	18.47	3156785.0
2009-04-06 11:30:00	MSFT	Stock	18.48	18.51	18.35	18.39	2219531.0
2009-04-06 12:00:00	MSFT	Stock	18.388	18.48	18.36	18.37	2078391.0
2009-04-06 12:30:00	MSFT	Stock	18.378	18.42	18.35	18.4	2261888.0
2009-04-06 13:00:00	MSFT	Stock	18.4	18.46	18.37	18.404	2327351.0
2009-04-06 13:30:00	MSFT	Stock	18.41	18.56	18.38	18.48	2898863.0
2009-04-06 14:00:00	MSFT	Stock	18.48	18.56	18.46	18.5	2530551.0
2009-04-06 14:30:00	MSFT	Stock	18.505	18.59	18.44	18.56	3169799.0
2009-04-06 15:00:00	MSFT	Stock	18.557	18.63	18.46	18.58	3741056.0
2009-04-06 15:30:00	MSFT	Stock	18.58	18.75	18.53	18.74	6689690.0
2009-04-06 16:00:00	MSFT	Stock	18.75	18.76	18.365	18.7	2174218.0
2009-04-06 16:30:00	MSFT	Stock	18.72	18.73	18.72	18.73	3900.0
2009-04-06 17:00:00	MSFT	Stock	18.72	18.78	18.72	18.73	11813.0
2009-04-06 17:30:00	MSFT	Stock	18.75	18.78	18.75	18.78	1490.0
2009-04-06 18:00:00	MSFT	Stock	18.76	18.76	18.75	18.75	13647.0
2009-04-06 18:30:00	MSFT	Stock	18.76	18.76	18.74	18.74	65510.0

> showing 50 of 69,387 rows — these rows as CSV

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