PREVIEW / stock_30min / 2010-08-17

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-08-17.parquet
  size:    1.4 MB
  rows:    75,289
  symbols: 3,472

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-08-17 05:00:00	AAPL	Stock	8.9261	8.9261	8.9261	8.9261	2884.0
2010-08-17 05:30:00	AAPL	Stock	8.9261	8.9261	8.9261	8.9261	2800.0
2010-08-17 07:00:00	AAPL	Stock	8.8964	8.9111	8.8929	8.9111	8568.0
2010-08-17 07:30:00	AAPL	Stock	8.9025	8.9132	8.9007	8.9132	39200.0
2010-08-17 08:00:00	AAPL	Stock	8.9039	8.9132	8.8911	8.9107	674548.0
2010-08-17 08:30:00	AAPL	Stock	8.9107	8.9407	8.9036	8.9311	1510628.0
2010-08-17 09:00:00	AAPL	Stock	8.9286	8.9393	8.9175	8.9375	898156.0
2010-08-17 09:30:00	AAPL	Stock	8.9314	8.9739	8.9	8.9691	61477808.0
2010-08-17 10:00:00	AAPL	Stock	8.9689	8.9975	8.9471	8.9678	50723904.0
2010-08-17 10:30:00	AAPL	Stock	8.9686	8.9993	8.9597	8.9946	29910272.0
2010-08-17 11:00:00	AAPL	Stock	8.9943	9.0204	8.9921	9.0157	32262720.0
2010-08-17 11:30:00	AAPL	Stock	9.0157	9.0411	9.0143	9.0389	27731228.0
2010-08-17 12:00:00	AAPL	Stock	9.0396	9.0475	9.0286	9.0386	24193092.0
2010-08-17 12:30:00	AAPL	Stock	9.0375	9.0621	9.0357	9.0579	18446680.0
2010-08-17 13:00:00	AAPL	Stock	9.0585	9.0939	9.0582	9.0814	28612780.0
2010-08-17 13:30:00	AAPL	Stock	9.0815	9.0832	9.0557	9.0582	18018476.0
2010-08-17 14:00:00	AAPL	Stock	9.0582	9.0721	9.0554	9.0664	14304388.0
2010-08-17 14:30:00	AAPL	Stock	9.0664	9.0689	9.0321	9.0448	24608024.0
2010-08-17 15:00:00	AAPL	Stock	9.045	9.0454	9.0182	9.0429	24365656.0
2010-08-17 15:30:00	AAPL	Stock	9.043	9.0461	8.9914	9.0043	48171200.0
2010-08-17 16:00:00	AAPL	Stock	8.9939	9.043	8.9864	8.998	11975684.0
2010-08-17 16:30:00	AAPL	Stock	8.9957	9.0489	8.9946	8.9946	718620.0
2010-08-17 17:00:00	AAPL	Stock	8.9921	8.9982	8.9921	8.9968	55608.0
2010-08-17 17:30:00	AAPL	Stock	8.9964	8.9979	8.9964	8.9964	14000.0
2010-08-17 18:00:00	AAPL	Stock	8.9989	8.9989	8.9964	8.9964	151340.0
2010-08-17 18:30:00	AAPL	Stock	8.9964	9.0	8.9964	8.9996	68992.0
2010-08-17 19:00:00	AAPL	Stock	8.9989	9.0107	8.9971	8.9982	71008.0
2010-08-17 19:30:00	AAPL	Stock	8.9982	9.0068	8.9975	9.0068	107324.0
2010-08-17 07:00:00	MSFT	Stock	24.68	24.68	24.68	24.68	1149.0
2010-08-17 07:30:00	MSFT	Stock	24.68	24.68	24.65	24.68	5097.0
2010-08-17 08:00:00	MSFT	Stock	24.67	24.69	24.65	24.67	19038.0
2010-08-17 08:30:00	MSFT	Stock	24.66	24.72	24.65	24.7	26777.0
2010-08-17 09:00:00	MSFT	Stock	24.72	24.72	24.7	24.71	20246.0
2010-08-17 09:30:00	MSFT	Stock	24.71	24.805	24.6	24.73	7405656.0
2010-08-17 10:00:00	MSFT	Stock	24.74	24.8	24.7	24.738	3938076.0
2010-08-17 10:30:00	MSFT	Stock	24.73	24.82	24.656	24.8	3412148.0
2010-08-17 11:00:00	MSFT	Stock	24.8	24.9	24.77	24.86	4384070.0
2010-08-17 11:30:00	MSFT	Stock	24.857	24.9	24.8	24.844	2990046.0
2010-08-17 12:00:00	MSFT	Stock	24.85	24.85	24.73	24.74	3044835.0
2010-08-17 12:30:00	MSFT	Stock	24.735	24.76	24.67	24.67	2803922.0
2010-08-17 13:00:00	MSFT	Stock	24.675	24.88	24.67	24.855	2916136.0
2010-08-17 13:30:00	MSFT	Stock	24.86	24.9	24.81	24.81	1936270.0
2010-08-17 14:00:00	MSFT	Stock	24.81	24.96	24.81	24.94	4098279.0
2010-08-17 14:30:00	MSFT	Stock	24.94	24.95	24.86	24.875	1834420.0
2010-08-17 15:00:00	MSFT	Stock	24.88	24.92	24.8	24.915	3539157.0
2010-08-17 15:30:00	MSFT	Stock	24.92	24.92	24.71	24.71	7131429.0
2010-08-17 16:00:00	MSFT	Stock	24.71	24.828	24.68	24.708	2463063.0
2010-08-17 16:30:00	MSFT	Stock	24.37	24.86	24.37	24.72	11000.0
2010-08-17 17:00:00	MSFT	Stock	24.71	24.76	24.71	24.76	29014.0
2010-08-17 17:30:00	MSFT	Stock	24.76	24.85	24.76	24.79	49204.0

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

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