PREVIEW / stock_30min / 2010-09-01

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-09-01.parquet
  size:    1.4 MB
  rows:    77,125
  symbols: 3,483

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-09-01 05:00:00	AAPL	Stock	8.7679	8.7679	8.7679	8.7679	5600.0
2010-09-01 05:30:00	AAPL	Stock	8.7675	8.7679	8.7571	8.7571	36400.0
2010-09-01 06:00:00	AAPL	Stock	8.7554	8.7571	8.7554	8.7571	25200.0
2010-09-01 06:30:00	AAPL	Stock	8.7679	8.7754	8.7679	8.7714	19600.0
2010-09-01 07:00:00	AAPL	Stock	8.7679	8.7821	8.7575	8.7764	211260.0
2010-09-01 07:30:00	AAPL	Stock	8.7686	8.7857	8.7686	8.7775	345408.0
2010-09-01 08:00:00	AAPL	Stock	8.775	8.8032	8.7721	8.8007	2570372.0
2010-09-01 08:30:00	AAPL	Stock	8.8021	8.8157	8.6821	8.7921	1696856.0
2010-09-01 09:00:00	AAPL	Stock	8.7943	8.85	8.7893	8.8379	2856728.0
2010-09-01 09:30:00	AAPL	Stock	8.8379	8.8561	8.7957	8.8357	76492500.0
2010-09-01 10:00:00	AAPL	Stock	8.8339	8.9025	8.8279	8.9022	79668148.0
2010-09-01 10:30:00	AAPL	Stock	8.9018	8.9339	8.8961	8.9268	54733448.0
2010-09-01 11:00:00	AAPL	Stock	8.9261	8.9643	8.9254	8.9543	40178964.0
2010-09-01 11:30:00	AAPL	Stock	8.955	8.9786	8.9518	8.9714	39170768.0
2010-09-01 12:00:00	AAPL	Stock	8.9714	8.9739	8.9504	8.9657	29096844.0
2010-09-01 12:30:00	AAPL	Stock	8.9646	8.9675	8.9393	8.9418	30993956.0
2010-09-01 13:00:00	AAPL	Stock	8.9418	8.9807	8.9225	8.9504	72558584.0
2010-09-01 13:30:00	AAPL	Stock	8.9514	8.9743	8.9344	8.9461	41099492.0
2010-09-01 14:00:00	AAPL	Stock	8.9468	8.9589	8.8943	8.9132	60460148.0
2010-09-01 14:30:00	AAPL	Stock	8.9132	8.9196	8.8829	8.9039	42974848.0
2010-09-01 15:00:00	AAPL	Stock	8.9043	8.9425	8.8886	8.9218	39614148.0
2010-09-01 15:30:00	AAPL	Stock	8.9207	8.9464	8.9143	8.9382	57302224.0
2010-09-01 16:00:00	AAPL	Stock	8.9393	8.9518	8.9171	8.9429	19929112.0
2010-09-01 16:30:00	AAPL	Stock	8.94	8.955	8.9184	8.9375	813456.0
2010-09-01 17:00:00	AAPL	Stock	8.9542	8.9542	8.9357	8.9389	2099524.0
2010-09-01 17:30:00	AAPL	Stock	8.9411	8.9464	8.9393	8.9446	178724.0
2010-09-01 18:00:00	AAPL	Stock	8.9421	8.9571	8.9421	8.9571	277676.0
2010-09-01 18:30:00	AAPL	Stock	8.9571	8.9571	8.9439	8.9464	167720.0
2010-09-01 19:00:00	AAPL	Stock	8.9443	8.9486	8.9393	8.9393	332220.0
2010-09-01 19:30:00	AAPL	Stock	8.9411	8.9532	8.9411	8.95	229068.0
2010-09-01 07:00:00	MSFT	Stock	23.75	23.79	23.7	23.73	4000.0
2010-09-01 07:30:00	MSFT	Stock	23.75	23.76	23.71	23.71	6702.0
2010-09-01 08:00:00	MSFT	Stock	23.78	23.78	23.48	23.72	39017.0
2010-09-01 08:30:00	MSFT	Stock	23.72	23.74	23.72	23.74	14310.0
2010-09-01 09:00:00	MSFT	Stock	23.75	23.89	23.63	23.66	133773.0
2010-09-01 09:30:00	MSFT	Stock	23.66	23.78	23.54	23.565	9533891.0
2010-09-01 10:00:00	MSFT	Stock	23.62	23.9	23.58	23.88	8953608.0
2010-09-01 10:30:00	MSFT	Stock	23.87	23.93	23.85	23.89	4772095.0
2010-09-01 11:00:00	MSFT	Stock	23.89	23.91	23.82	23.82	2929270.0
2010-09-01 11:30:00	MSFT	Stock	23.83	23.875	23.81	23.81	2941916.0
2010-09-01 12:00:00	MSFT	Stock	23.82	23.82	23.76	23.783	2981179.0
2010-09-01 12:30:00	MSFT	Stock	23.782	23.83	23.78	23.79	2162650.0
2010-09-01 13:00:00	MSFT	Stock	23.795	23.8	23.75	23.775	3350920.0
2010-09-01 13:30:00	MSFT	Stock	23.771	23.84	23.77	23.83	2259273.0
2010-09-01 14:00:00	MSFT	Stock	23.835	23.85	23.77	23.8	2655099.0
2010-09-01 14:30:00	MSFT	Stock	23.802	23.83	23.77	23.821	3286044.0
2010-09-01 15:00:00	MSFT	Stock	23.82	23.88	23.8	23.85	4236204.0
2010-09-01 15:30:00	MSFT	Stock	23.845	23.95	23.84	23.92	9682363.0
2010-09-01 16:00:00	MSFT	Stock	23.91	23.95	23.782	23.91	4143797.0
2010-09-01 16:30:00	MSFT	Stock	23.809	23.92	23.809	23.9	185050.0

> showing 50 of 77,125 rows — these rows as CSV

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