PREVIEW / stock_30min / 2010-08-18

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-08-18.parquet
  size:    1.4 MB
  rows:    74,867
  symbols: 3,469

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-18 04:00:00	AAPL	Stock	8.9964	8.9964	8.9964	8.9964	11900.0
2010-08-18 04:30:00	AAPL	Stock	9.0214	9.0214	9.0214	9.0214	2800.0
2010-08-18 05:00:00	AAPL	Stock	9.0214	9.0214	9.0214	9.0214	11200.0
2010-08-18 05:30:00	AAPL	Stock	9.0286	9.0286	9.0286	9.0286	9324.0
2010-08-18 06:00:00	AAPL	Stock	9.0286	9.0286	9.0286	9.0286	2800.0
2010-08-18 06:30:00	AAPL	Stock	9.025	9.025	9.0246	9.0246	5600.0
2010-08-18 07:00:00	AAPL	Stock	9.0071	9.0071	9.0071	9.0071	5600.0
2010-08-18 07:30:00	AAPL	Stock	9.0175	9.0346	9.0161	9.0307	87920.0
2010-08-18 08:00:00	AAPL	Stock	9.0286	9.0286	8.9964	9.0261	773276.0
2010-08-18 08:30:00	AAPL	Stock	9.0264	9.0461	9.02	9.0443	887264.0
2010-08-18 09:00:00	AAPL	Stock	9.0443	9.0496	9.0121	9.0132	936180.0
2010-08-18 09:30:00	AAPL	Stock	9.0186	9.0414	8.985	9.0407	53850804.0
2010-08-18 10:00:00	AAPL	Stock	9.0407	9.08	9.0161	9.0268	44401196.0
2010-08-18 10:30:00	AAPL	Stock	9.0289	9.0529	9.0221	9.0457	17151512.0
2010-08-18 11:00:00	AAPL	Stock	9.0449	9.0682	9.0357	9.0614	22740088.0
2010-08-18 11:30:00	AAPL	Stock	9.061	9.075	9.0539	9.0693	20462512.0
2010-08-18 12:00:00	AAPL	Stock	9.0689	9.0786	9.0622	9.065	16281748.0
2010-08-18 12:30:00	AAPL	Stock	9.065	9.0786	9.0432	9.0764	17126144.0
2010-08-18 13:00:00	AAPL	Stock	9.0768	9.0954	9.0718	9.0839	22285004.0
2010-08-18 13:30:00	AAPL	Stock	9.0836	9.0911	9.0729	9.0775	14253960.0
2010-08-18 14:00:00	AAPL	Stock	9.0782	9.0836	9.0539	9.0814	20276620.0
2010-08-18 14:30:00	AAPL	Stock	9.0811	9.0821	9.0564	9.0571	13212892.0
2010-08-18 15:00:00	AAPL	Stock	9.0571	9.0654	9.025	9.0354	25748100.0
2010-08-18 15:30:00	AAPL	Stock	9.0354	9.0557	9.0289	9.0382	33052572.0
2010-08-18 16:00:00	AAPL	Stock	9.0382	9.0552	8.9982	9.0107	12995500.0
2010-08-18 16:30:00	AAPL	Stock	9.0143	9.0604	9.0004	9.0107	311528.0
2010-08-18 17:00:00	AAPL	Stock	9.0107	9.0171	9.0036	9.0171	184828.0
2010-08-18 17:30:00	AAPL	Stock	9.0143	9.025	9.0125	9.02	79380.0
2010-08-18 18:00:00	AAPL	Stock	9.02	9.0382	9.0143	9.0311	276472.0
2010-08-18 18:30:00	AAPL	Stock	9.0304	9.0321	9.0214	9.0321	325948.0
2010-08-18 19:00:00	AAPL	Stock	9.0307	9.0311	9.025	9.025	101640.0
2010-08-18 19:30:00	AAPL	Stock	9.0221	9.0243	9.0179	9.0214	127400.0
2010-08-18 20:00:00	AAPL	Stock	9.0029	9.0654	9.0029	9.0654	584360.0
2010-08-18 07:00:00	MSFT	Stock	24.82	24.82	24.82	24.82	101.0
2010-08-18 08:00:00	MSFT	Stock	24.82	24.82	24.76	24.76	4660.0
2010-08-18 08:30:00	MSFT	Stock	24.79	24.8	24.79	24.79	9568.0
2010-08-18 09:00:00	MSFT	Stock	24.8	24.8	24.65	24.68	91376.0
2010-08-18 09:30:00	MSFT	Stock	24.68	24.68	24.41	24.64	6663560.0
2010-08-18 10:00:00	MSFT	Stock	24.64	24.7	24.55	24.57	4360854.0
2010-08-18 10:30:00	MSFT	Stock	24.58	24.65	24.54	24.59	3066300.0
2010-08-18 11:00:00	MSFT	Stock	24.582	24.65	24.56	24.599	3181237.0
2010-08-18 11:30:00	MSFT	Stock	24.6	24.835	24.59	24.814	3848207.0
2010-08-18 12:00:00	MSFT	Stock	24.81	24.83	24.78	24.8	1829499.0
2010-08-18 12:30:00	MSFT	Stock	24.79	24.87	24.77	24.82	1812159.0
2010-08-18 13:00:00	MSFT	Stock	24.82	24.93	24.82	24.888	2862705.0
2010-08-18 13:30:00	MSFT	Stock	24.88	24.95	24.87	24.9	1536303.0
2010-08-18 14:00:00	MSFT	Stock	24.92	24.95	24.86	24.88	1696107.0
2010-08-18 14:30:00	MSFT	Stock	24.89	24.91	24.83	24.87	1718692.0
2010-08-18 15:00:00	MSFT	Stock	24.872	24.89	24.83	24.85	2464118.0
2010-08-18 15:30:00	MSFT	Stock	24.851	24.9	24.82	24.86	7007378.0

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

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