PREVIEW / stock_30min / 2010-04-12

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-04-12.parquet
  size:    1.4 MB
  rows:    74,781
  symbols: 3,492

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-12 04:00:00	AAPL	Stock	8.6629	8.6629	8.6629	8.6629	13300.0
2010-04-12 04:30:00	AAPL	Stock	8.6746	8.6746	8.6746	8.6746	23016.0
2010-04-12 05:00:00	AAPL	Stock	8.6746	8.675	8.6714	8.6714	11228.0
2010-04-12 05:30:00	AAPL	Stock	8.6614	8.6614	8.6614	8.6614	8400.0
2010-04-12 06:00:00	AAPL	Stock	8.6607	8.6607	8.6607	8.6607	13216.0
2010-04-12 06:30:00	AAPL	Stock	8.6607	8.6607	8.6607	8.6607	34048.0
2010-04-12 07:00:00	AAPL	Stock	8.6625	8.6629	8.6436	8.6436	138460.0
2010-04-12 07:30:00	AAPL	Stock	8.6464	8.6518	8.6375	8.6429	53228.0
2010-04-12 08:00:00	AAPL	Stock	8.65	8.6571	8.6411	8.6461	1235332.0
2010-04-12 08:30:00	AAPL	Stock	8.6446	8.6486	8.6396	8.6429	502936.0
2010-04-12 09:00:00	AAPL	Stock	8.6429	8.6571	8.6429	8.6571	1146740.0
2010-04-12 09:30:00	AAPL	Stock	8.6518	8.675	8.6361	8.6407	57202460.0
2010-04-12 10:00:00	AAPL	Stock	8.64	8.6721	8.6389	8.6714	36511720.0
2010-04-12 10:30:00	AAPL	Stock	8.6718	8.6718	8.6518	8.6679	29011388.0
2010-04-12 11:00:00	AAPL	Stock	8.6668	8.6746	8.6554	8.6636	23141132.0
2010-04-12 11:30:00	AAPL	Stock	8.6625	8.6707	8.6575	8.6679	13388536.0
2010-04-12 12:00:00	AAPL	Stock	8.6679	8.6714	8.6586	8.6627	11567864.0
2010-04-12 12:30:00	AAPL	Stock	8.6625	8.6689	8.6589	8.6636	10548524.0
2010-04-12 13:00:00	AAPL	Stock	8.6636	8.6768	8.6636	8.6729	13990480.0
2010-04-12 13:30:00	AAPL	Stock	8.6725	8.6811	8.6625	8.6629	22447684.0
2010-04-12 14:00:00	AAPL	Stock	8.6632	8.6675	8.6554	8.665	18414480.0
2010-04-12 14:30:00	AAPL	Stock	8.6661	8.6743	8.6615	8.6718	13268220.0
2010-04-12 15:00:00	AAPL	Stock	8.6721	8.6739	8.6546	8.6611	22777944.0
2010-04-12 15:30:00	AAPL	Stock	8.6607	8.6639	8.6429	8.6539	39840024.0
2010-04-12 16:00:00	AAPL	Stock	8.6532	8.6685	8.6479	8.6532	12710628.0
2010-04-12 16:30:00	AAPL	Stock	8.6491	8.6665	8.6491	8.6525	459424.0
2010-04-12 17:00:00	AAPL	Stock	8.6511	8.6512	8.6468	8.6468	126168.0
2010-04-12 17:30:00	AAPL	Stock	8.6482	8.6529	8.6482	8.6529	54572.0
2010-04-12 18:00:00	AAPL	Stock	8.6525	8.6529	8.65	8.65	60004.0
2010-04-12 18:30:00	AAPL	Stock	8.6486	8.6532	8.6486	8.6532	31024.0
2010-04-12 19:00:00	AAPL	Stock	8.65	8.6507	8.65	8.6507	19600.0
2010-04-12 19:30:00	AAPL	Stock	8.6507	8.6525	8.6486	8.6486	69048.0
2010-04-12 20:00:00	AAPL	Stock	8.6596	8.6596	8.6596	8.6596	33600.0
2010-04-12 08:00:00	MSFT	Stock	30.37	30.4	30.34	30.39	7799.0
2010-04-12 08:30:00	MSFT	Stock	30.39	30.39	30.31	30.31	8668.0
2010-04-12 09:00:00	MSFT	Stock	30.3	30.37	30.25	30.27	44151.0
2010-04-12 09:30:00	MSFT	Stock	30.28	30.415	30.205	30.31	4230451.0
2010-04-12 10:00:00	MSFT	Stock	30.31	30.49	30.27	30.449	4121530.0
2010-04-12 10:30:00	MSFT	Stock	30.44	30.45	30.31	30.32	2989170.0
2010-04-12 11:00:00	MSFT	Stock	30.32	30.34	30.27	30.313	2290418.0
2010-04-12 11:30:00	MSFT	Stock	30.31	30.4	30.3	30.391	1527161.0
2010-04-12 12:00:00	MSFT	Stock	30.4	30.42	30.33	30.394	1354144.0
2010-04-12 12:30:00	MSFT	Stock	30.391	30.4	30.32	30.36	1541883.0
2010-04-12 13:00:00	MSFT	Stock	30.36	30.4	30.32	30.33	2722441.0
2010-04-12 13:30:00	MSFT	Stock	30.33	30.386	30.31	30.322	1961775.0
2010-04-12 14:00:00	MSFT	Stock	30.32	30.37	30.32	30.36	1734993.0
2010-04-12 14:30:00	MSFT	Stock	30.365	30.44	30.35	30.44	2071910.0
2010-04-12 15:00:00	MSFT	Stock	30.44	30.44	30.31	30.33	2545950.0
2010-04-12 15:30:00	MSFT	Stock	30.335	30.38	30.31	30.32	4898953.0
2010-04-12 16:00:00	MSFT	Stock	30.32	30.377	30.319	30.33	2151202.0

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

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