PREVIEW / stock_30min / 2012-01-09

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-01-09.parquet
  size:    1.4 MB
  rows:    77,655
  symbols: 3,534

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
2012-01-09 04:00:00	AAPL	Stock	15.1254	15.1429	15.1254	15.1429	6160.0
2012-01-09 05:00:00	AAPL	Stock	15.125	15.125	15.1075	15.1075	58800.0
2012-01-09 06:00:00	AAPL	Stock	15.0982	15.0982	15.0914	15.0914	30800.0
2012-01-09 07:00:00	AAPL	Stock	15.0964	15.1475	15.0914	15.1429	363188.0
2012-01-09 07:30:00	AAPL	Stock	15.1425	15.1582	15.1304	15.1429	393092.0
2012-01-09 08:00:00	AAPL	Stock	15.1332	15.1643	15.1232	15.1579	1454236.0
2012-01-09 08:30:00	AAPL	Stock	15.1607	15.2107	15.1518	15.1889	1679216.0
2012-01-09 09:00:00	AAPL	Stock	15.1889	15.2425	15.1786	15.2029	3967264.0
2012-01-09 09:30:00	AAPL	Stock	15.2018	15.2418	15.1632	15.2193	67329752.0
2012-01-09 10:00:00	AAPL	Stock	15.2193	15.2636	15.1921	15.2418	43748768.0
2012-01-09 10:30:00	AAPL	Stock	15.2432	15.2768	15.2	15.2139	37029384.0
2012-01-09 11:00:00	AAPL	Stock	15.2128	15.2143	15.1668	15.205	30386104.0
2012-01-09 11:30:00	AAPL	Stock	15.2039	15.2111	15.1029	15.1068	25962664.0
2012-01-09 12:00:00	AAPL	Stock	15.1068	15.1429	15.0482	15.1425	38677604.0
2012-01-09 12:30:00	AAPL	Stock	15.1404	15.1518	15.1325	15.1421	13566588.0
2012-01-09 13:00:00	AAPL	Stock	15.1425	15.1525	15.1207	15.1361	11604992.0
2012-01-09 13:30:00	AAPL	Stock	15.1364	15.1405	15.1111	15.1189	9545760.0
2012-01-09 14:00:00	AAPL	Stock	15.1196	15.1782	15.1143	15.1616	14928984.0
2012-01-09 14:30:00	AAPL	Stock	15.1618	15.1782	15.0893	15.1139	17137008.0
2012-01-09 15:00:00	AAPL	Stock	15.1145	15.135	15.0907	15.1082	14888832.0
2012-01-09 15:30:00	AAPL	Stock	15.1064	15.1164	15.0543	15.0618	35241584.0
2012-01-09 16:00:00	AAPL	Stock	15.0579	15.1786	15.0536	15.0554	16082724.0
2012-01-09 16:30:00	AAPL	Stock	15.0625	15.216	15.0568	15.0711	398104.0
2012-01-09 17:00:00	AAPL	Stock	15.0707	15.0757	15.0661	15.0757	68656.0
2012-01-09 17:30:00	AAPL	Stock	15.075	15.075	15.0446	15.06	159936.0
2012-01-09 18:00:00	AAPL	Stock	15.0568	15.075	15.0568	15.075	158732.0
2012-01-09 18:30:00	AAPL	Stock	15.0768	15.0875	15.0732	15.0868	61208.0
2012-01-09 19:00:00	AAPL	Stock	15.0875	15.1071	15.0875	15.1071	147196.0
2012-01-09 19:30:00	AAPL	Stock	15.1096	15.1143	15.0989	15.1018	128660.0
2012-01-09 06:30:00	MSFT	Stock	28.1	28.1	28.1	28.1	2500.0
2012-01-09 07:00:00	MSFT	Stock	28.0	28.0	28.0	28.0	475.0
2012-01-09 07:30:00	MSFT	Stock	28.22	28.22	28.1	28.1	700.0
2012-01-09 08:00:00	MSFT	Stock	28.15	28.18	28.12	28.16	14100.0
2012-01-09 08:30:00	MSFT	Stock	28.16	28.17	28.14	28.17	13800.0
2012-01-09 09:00:00	MSFT	Stock	28.17	28.18	28.01	28.05	86606.0
2012-01-09 09:30:00	MSFT	Stock	28.04	28.1	27.93	28.02	9242014.0
2012-01-09 10:00:00	MSFT	Stock	28.015	28.02	27.91	28.0	4716782.0
2012-01-09 10:30:00	MSFT	Stock	27.995	28.03	27.88	27.9	4832179.0
2012-01-09 11:00:00	MSFT	Stock	27.895	27.9	27.73	27.79	3922709.0
2012-01-09 11:30:00	MSFT	Stock	27.8	27.94	27.793	27.88	4118534.0
2012-01-09 12:00:00	MSFT	Stock	27.89	27.95	27.83	27.845	2604359.0
2012-01-09 12:30:00	MSFT	Stock	27.85	27.85	27.76	27.79	3442674.0
2012-01-09 13:00:00	MSFT	Stock	27.785	27.85	27.76	27.84	2496503.0
2012-01-09 13:30:00	MSFT	Stock	27.845	27.87	27.8	27.81	2213403.0
2012-01-09 14:00:00	MSFT	Stock	27.815	27.85	27.76	27.781	3065154.0
2012-01-09 14:30:00	MSFT	Stock	27.785	27.85	27.76	27.796	2534242.0
2012-01-09 15:00:00	MSFT	Stock	27.79	27.81	27.77	27.8	3258997.0
2012-01-09 15:30:00	MSFT	Stock	27.795	27.8	27.72	27.74	9662633.0
2012-01-09 16:00:00	MSFT	Stock	27.73	28.11	27.73	27.74	2372127.0
2012-01-09 16:30:00	MSFT	Stock	27.74	27.867	27.7	27.7	118298.0

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

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