PREVIEW / stock_30min / 2013-09-12

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-09-12.parquet
  size:    1.5 MB
  rows:    79,552
  symbols: 3,517

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
2013-09-12 04:00:00	AAPL	Stock	16.7768	16.7768	16.6968	16.75	35056.0
2013-09-12 04:30:00	AAPL	Stock	16.7414	16.7714	16.7414	16.7482	52332.0
2013-09-12 05:00:00	AAPL	Stock	16.7396	16.7475	16.7296	16.7461	84168.0
2013-09-12 05:30:00	AAPL	Stock	16.7461	16.7821	16.7461	16.7821	70644.0
2013-09-12 06:00:00	AAPL	Stock	16.7939	16.8132	16.7921	16.8021	84560.0
2013-09-12 06:30:00	AAPL	Stock	16.8004	16.8036	16.7782	16.7782	78400.0
2013-09-12 07:00:00	AAPL	Stock	16.7714	16.8157	16.7714	16.8107	239792.0
2013-09-12 07:30:00	AAPL	Stock	16.8132	16.8139	16.785	16.7975	301224.0
2013-09-12 08:00:00	AAPL	Stock	16.8036	16.9018	16.7768	16.8486	3082380.0
2013-09-12 08:30:00	AAPL	Stock	16.8571	16.8586	16.81	16.8275	1049720.0
2013-09-12 09:00:00	AAPL	Stock	16.825	16.8296	16.7271	16.7318	1911924.0
2013-09-12 09:30:00	AAPL	Stock	16.7321	16.8204	16.6432	16.7696	78743532.0
2013-09-12 10:00:00	AAPL	Stock	16.7702	16.7918	16.6821	16.7536	34914152.0
2013-09-12 10:30:00	AAPL	Stock	16.7536	16.8032	16.7296	16.7789	26730116.0
2013-09-12 11:00:00	AAPL	Stock	16.7807	16.9054	16.7779	16.8943	45605112.0
2013-09-12 11:30:00	AAPL	Stock	16.8982	16.9018	16.845	16.8887	21161420.0
2013-09-12 12:00:00	AAPL	Stock	16.8907	16.9532	16.8686	16.9468	24336732.0
2013-09-12 12:30:00	AAPL	Stock	16.9468	16.9786	16.9018	16.9019	30847208.0
2013-09-12 13:00:00	AAPL	Stock	16.9057	16.9489	16.8771	16.9071	21925232.0
2013-09-12 13:30:00	AAPL	Stock	16.9086	16.925	16.8821	16.8822	9069480.0
2013-09-12 14:00:00	AAPL	Stock	16.8839	16.9164	16.8643	16.9096	15744932.0
2013-09-12 14:30:00	AAPL	Stock	16.9129	16.9329	16.8693	16.8887	15775396.0
2013-09-12 15:00:00	AAPL	Stock	16.8884	16.9018	16.815	16.8382	21409864.0
2013-09-12 15:30:00	AAPL	Stock	16.8396	16.9068	16.8271	16.8818	35429016.0
2013-09-12 16:00:00	AAPL	Stock	16.8818	16.8972	16.8358	16.8857	10175676.0
2013-09-12 16:30:00	AAPL	Stock	16.8821	16.8851	16.8627	16.8814	227388.0
2013-09-12 17:00:00	AAPL	Stock	16.8793	16.8804	16.8661	16.8661	232008.0
2013-09-12 17:30:00	AAPL	Stock	16.8775	16.8814	16.875	16.8804	72240.0
2013-09-12 18:00:00	AAPL	Stock	16.88	16.8871	16.8768	16.8839	138264.0
2013-09-12 18:30:00	AAPL	Stock	16.8832	16.8857	16.8782	16.8857	48552.0
2013-09-12 19:00:00	AAPL	Stock	16.8804	16.8979	16.8804	16.8979	120120.0
2013-09-12 19:30:00	AAPL	Stock	16.8975	16.9036	16.8857	16.8943	243684.0
2013-09-12 04:30:00	MSFT	Stock	32.99	32.99	32.99	32.99	300.0
2013-09-12 08:00:00	MSFT	Stock	32.76	32.97	32.75	32.9	16894.0
2013-09-12 08:30:00	MSFT	Stock	32.95	32.95	32.9	32.91	5480.0
2013-09-12 09:00:00	MSFT	Stock	32.88	32.89	32.69	32.7	28456.0
2013-09-12 09:30:00	MSFT	Stock	32.72	32.78	32.67	32.735	4098352.0
2013-09-12 10:00:00	MSFT	Stock	32.73	32.76	32.65	32.75	2703007.0
2013-09-12 10:30:00	MSFT	Stock	32.75	32.76	32.61	32.635	2085695.0
2013-09-12 11:00:00	MSFT	Stock	32.63	32.67	32.6	32.66	3104911.0
2013-09-12 11:30:00	MSFT	Stock	32.66	32.677	32.59	32.67	3439982.0
2013-09-12 12:00:00	MSFT	Stock	32.67	32.68	32.61	32.654	1267333.0
2013-09-12 12:30:00	MSFT	Stock	32.66	32.7	32.64	32.685	953568.0
2013-09-12 13:00:00	MSFT	Stock	32.69	32.76	32.68	32.755	1015527.0
2013-09-12 13:30:00	MSFT	Stock	32.75	32.76	32.64	32.64	1320695.0
2013-09-12 14:00:00	MSFT	Stock	32.64	32.67	32.64	32.645	1264580.0
2013-09-12 14:30:00	MSFT	Stock	32.64	32.71	32.625	32.705	1675903.0
2013-09-12 15:00:00	MSFT	Stock	32.71	32.71	32.65	32.65	1642017.0
2013-09-12 15:30:00	MSFT	Stock	32.65	32.71	32.6	32.71	5152169.0
2013-09-12 16:00:00	MSFT	Stock	32.71	32.751	32.625	32.71	1577655.0

> showing 50 of 79,552 rows — these rows as CSV

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