PREVIEW / stock_30min / 2010-01-05

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-01-05.parquet
  size:    1.4 MB
  rows:    73,351
  symbols: 3,454

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-01-05 05:00:00	AAPL	Stock	7.6911	7.6911	7.6782	7.6782	8400.0
2010-01-05 05:30:00	AAPL	Stock	7.6768	7.6768	7.6768	7.6768	19600.0
2010-01-05 06:00:00	AAPL	Stock	7.675	7.6768	7.6714	7.6714	22400.0
2010-01-05 06:30:00	AAPL	Stock	7.6768	7.6768	7.675	7.675	22400.0
2010-01-05 07:00:00	AAPL	Stock	7.67	7.6882	7.6686	7.6714	430808.0
2010-01-05 07:30:00	AAPL	Stock	7.6825	7.6825	7.6714	7.6786	78680.0
2010-01-05 08:00:00	AAPL	Stock	7.6786	7.7036	7.65	7.655	5499984.0
2010-01-05 08:30:00	AAPL	Stock	7.6568	7.6671	7.6354	7.645	3124184.0
2010-01-05 09:00:00	AAPL	Stock	7.6443	7.6621	7.6368	7.6621	2514988.0
2010-01-05 09:30:00	AAPL	Stock	7.66	7.6996	7.6225	7.6871	123781644.0
2010-01-05 10:00:00	AAPL	Stock	7.6864	7.6986	7.6714	7.6843	60125408.0
2010-01-05 10:30:00	AAPL	Stock	7.6846	7.6875	7.6589	7.6723	40906292.0
2010-01-05 11:00:00	AAPL	Stock	7.6721	7.6764	7.6511	7.6682	29040480.0
2010-01-05 11:30:00	AAPL	Stock	7.6686	7.6868	7.6664	7.6821	27120576.0
2010-01-05 12:00:00	AAPL	Stock	7.6829	7.69	7.6736	7.6854	62290900.0
2010-01-05 12:30:00	AAPL	Stock	7.685	7.6857	7.6618	7.6757	16488248.0
2010-01-05 13:00:00	AAPL	Stock	7.6754	7.6829	7.6575	7.6721	16404864.0
2010-01-05 13:30:00	AAPL	Stock	7.6718	7.6846	7.6596	7.6634	21490028.0
2010-01-05 14:00:00	AAPL	Stock	7.6636	7.6718	7.6161	7.6393	60986100.0
2010-01-05 14:30:00	AAPL	Stock	7.6394	7.6621	7.6368	7.6575	29509172.0
2010-01-05 15:00:00	AAPL	Stock	7.6571	7.6664	7.6396	7.6482	23902620.0
2010-01-05 15:30:00	AAPL	Stock	7.6479	7.6643	7.6454	7.6564	32012036.0
2010-01-05 16:00:00	AAPL	Stock	7.6675	7.683	7.6534	7.6589	9438548.0
2010-01-05 16:30:00	AAPL	Stock	7.6496	7.6654	7.6496	7.6575	721168.0
2010-01-05 17:00:00	AAPL	Stock	7.6586	7.6671	7.6586	7.6657	187768.0
2010-01-05 17:30:00	AAPL	Stock	7.6654	7.6654	7.6589	7.6595	218540.0
2010-01-05 18:00:00	AAPL	Stock	7.6595	7.6632	7.6593	7.66	123760.0
2010-01-05 18:30:00	AAPL	Stock	7.6607	7.6636	7.66	7.6614	61600.0
2010-01-05 19:00:00	AAPL	Stock	7.6593	7.6632	7.6593	7.6632	43344.0
2010-01-05 19:30:00	AAPL	Stock	7.66	7.6607	7.6571	7.6593	141820.0
2010-01-05 07:00:00	MSFT	Stock	30.81	30.81	30.81	30.81	164.0
2010-01-05 08:00:00	MSFT	Stock	30.89	30.95	30.85	30.85	19415.0
2010-01-05 08:30:00	MSFT	Stock	30.82	30.9	30.82	30.89	10470.0
2010-01-05 09:00:00	MSFT	Stock	30.89	30.89	30.85	30.89	11027.0
2010-01-05 09:30:00	MSFT	Stock	30.85	31.09	30.85	30.99	8279109.0
2010-01-05 10:00:00	MSFT	Stock	30.99	31.1	30.94	31.01	4417059.0
2010-01-05 10:30:00	MSFT	Stock	31.01	31.07	31.0	31.015	3019830.0
2010-01-05 11:00:00	MSFT	Stock	31.018	31.08	30.98	30.98	3622254.0
2010-01-05 11:30:00	MSFT	Stock	30.98	30.98	30.92	30.94	1788390.0
2010-01-05 12:00:00	MSFT	Stock	30.934	30.99	30.87	30.89	2603411.0
2010-01-05 12:30:00	MSFT	Stock	30.89	30.9	30.75	30.81	3074219.0
2010-01-05 13:00:00	MSFT	Stock	30.81	30.83	30.69	30.748	2316665.0
2010-01-05 13:30:00	MSFT	Stock	30.74	30.79	30.72	30.75	1691833.0
2010-01-05 14:00:00	MSFT	Stock	30.75	30.77	30.64	30.71	2799266.0
2010-01-05 14:30:00	MSFT	Stock	30.71	30.92	30.71	30.91	2344208.0
2010-01-05 15:00:00	MSFT	Stock	30.92	30.97	30.87	30.935	2686488.0
2010-01-05 15:30:00	MSFT	Stock	30.93	31.0	30.91	30.95	5403814.0
2010-01-05 16:00:00	MSFT	Stock	30.94	30.98	30.908	30.935	3861945.0
2010-01-05 16:30:00	MSFT	Stock	30.944	30.97	30.917	30.96	98781.0
2010-01-05 17:00:00	MSFT	Stock	30.871	30.98	30.871	30.98	96310.0

> showing 50 of 73,351 rows — these rows as CSV

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