PREVIEW / stock_30min / 2011-10-17

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-10-17.parquet
  size:    1.4 MB
  rows:    72,992
  symbols: 3,476

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
2011-10-17 04:00:00	AAPL	Stock	15.17	15.17	15.17	15.17	8400.0
2011-10-17 04:30:00	AAPL	Stock	15.2057	15.2143	15.2057	15.2143	20300.0
2011-10-17 05:00:00	AAPL	Stock	15.2321	15.2321	15.2143	15.2143	41720.0
2011-10-17 05:30:00	AAPL	Stock	15.1536	15.1786	15.1304	15.1786	86520.0
2011-10-17 06:00:00	AAPL	Stock	15.1429	15.1607	15.1429	15.1607	67200.0
2011-10-17 06:30:00	AAPL	Stock	15.1457	15.1457	15.0893	15.0921	115108.0
2011-10-17 07:00:00	AAPL	Stock	15.1061	15.1429	15.0914	15.1339	670712.0
2011-10-17 07:30:00	AAPL	Stock	15.1425	15.1964	15.1071	15.1096	845460.0
2011-10-17 08:00:00	AAPL	Stock	15.1229	15.1679	15.1075	15.1589	2997120.0
2011-10-17 08:30:00	AAPL	Stock	15.1443	15.1732	15.0714	15.0789	5604788.0
2011-10-17 09:00:00	AAPL	Stock	15.08	15.0907	14.9918	15.0589	4930128.0
2011-10-17 09:30:00	AAPL	Stock	15.0621	15.1321	15.0036	15.0784	94148628.0
2011-10-17 10:00:00	AAPL	Stock	15.08	15.1818	15.0464	15.1621	73603152.0
2011-10-17 10:30:00	AAPL	Stock	15.1568	15.2393	15.1518	15.1842	61628420.0
2011-10-17 11:00:00	AAPL	Stock	15.1811	15.2107	15.0714	15.1904	33314624.0
2011-10-17 11:30:00	AAPL	Stock	15.1889	15.2036	15.0289	15.0504	49935452.0
2011-10-17 12:00:00	AAPL	Stock	15.0471	15.0693	14.9714	15.0379	54802188.0
2011-10-17 12:30:00	AAPL	Stock	15.0393	15.0418	14.855	14.9404	65785020.0
2011-10-17 13:00:00	AAPL	Stock	14.9396	15.0211	14.8932	14.9871	35394352.0
2011-10-17 13:30:00	AAPL	Stock	14.9861	15.0086	14.9218	14.9832	27218800.0
2011-10-17 14:00:00	AAPL	Stock	14.9864	14.9964	14.9536	14.9698	16205504.0
2011-10-17 14:30:00	AAPL	Stock	14.97	14.9704	14.8821	14.9607	32837588.0
2011-10-17 15:00:00	AAPL	Stock	14.9607	15.0206	14.9468	14.9913	37902368.0
2011-10-17 15:30:00	AAPL	Stock	14.9872	15.025	14.95	14.9918	53608464.0
2011-10-17 16:00:00	AAPL	Stock	14.9918	15.0467	14.8957	14.9211	16661064.0
2011-10-17 16:30:00	AAPL	Stock	14.9271	15.0481	14.8943	14.9464	10523296.0
2011-10-17 17:00:00	AAPL	Stock	14.93	14.9375	14.8929	14.9054	548436.0
2011-10-17 17:30:00	AAPL	Stock	14.9018	14.9425	14.8929	14.9411	368844.0
2011-10-17 18:00:00	AAPL	Stock	14.9414	14.9996	14.9379	14.9379	273588.0
2011-10-17 18:30:00	AAPL	Stock	14.9464	14.9761	14.9329	14.9761	144760.0
2011-10-17 19:00:00	AAPL	Stock	14.9654	14.985	14.9571	14.975	150472.0
2011-10-17 19:30:00	AAPL	Stock	14.9846	14.9846	14.9471	14.9561	373940.0
2011-10-17 04:00:00	MSFT	Stock	27.4	27.4	27.4	27.4	100.0
2011-10-17 07:00:00	MSFT	Stock	27.35	27.41	27.3	27.41	2399.0
2011-10-17 07:30:00	MSFT	Stock	27.23	27.23	27.18	27.18	1900.0
2011-10-17 08:00:00	MSFT	Stock	27.25	27.25	27.19	27.19	965.0
2011-10-17 08:30:00	MSFT	Stock	27.22	27.24	27.16	27.16	4545.0
2011-10-17 09:00:00	MSFT	Stock	27.13	27.22	27.08	27.13	62123.0
2011-10-17 09:30:00	MSFT	Stock	27.114	27.42	27.08	27.205	4140325.0
2011-10-17 10:00:00	MSFT	Stock	27.2	27.25	27.02	27.04	3225018.0
2011-10-17 10:30:00	MSFT	Stock	27.035	27.055	27.01	27.02	2691640.0
2011-10-17 11:00:00	MSFT	Stock	27.018	27.16	27.01	27.145	1864730.0
2011-10-17 11:30:00	MSFT	Stock	27.145	27.19	27.07	27.08	2444908.0
2011-10-17 12:00:00	MSFT	Stock	27.08	27.1	27.02	27.09	1890389.0
2011-10-17 12:30:00	MSFT	Stock	27.09	27.14	27.06	27.07	1679322.0
2011-10-17 13:00:00	MSFT	Stock	27.06	27.08	27.0	27.034	1672307.0
2011-10-17 13:30:00	MSFT	Stock	27.035	27.075	26.98	27.03	2108798.0
2011-10-17 14:00:00	MSFT	Stock	27.035	27.04	26.93	26.985	1692078.0
2011-10-17 14:30:00	MSFT	Stock	26.982	26.986	26.85	26.98	2120442.0
2011-10-17 15:00:00	MSFT	Stock	26.98	27.04	26.95	26.98	2286988.0

> showing 50 of 72,992 rows — these rows as CSV

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