PREVIEW / stock_30min / 2012-06-18

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-06-18.parquet
  size:    1.4 MB
  rows:    76,023
  symbols: 3,518

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-06-18 04:00:00	AAPL	Stock	20.5414	20.5414	20.4893	20.4893	94220.0
2012-06-18 06:30:00	AAPL	Stock	20.4886	20.4886	20.4864	20.4864	25200.0
2012-06-18 07:00:00	AAPL	Stock	20.5	20.5	20.4571	20.465	139636.0
2012-06-18 07:30:00	AAPL	Stock	20.4646	20.475	20.4382	20.4514	103348.0
2012-06-18 08:00:00	AAPL	Stock	20.4557	20.4721	20.4425	20.4521	338380.0
2012-06-18 08:30:00	AAPL	Stock	20.4521	20.5046	20.3789	20.4275	1428728.0
2012-06-18 09:00:00	AAPL	Stock	20.4239	20.4243	20.3871	20.3882	1622488.0
2012-06-18 09:30:00	AAPL	Stock	20.3914	20.6924	20.3704	20.6118	67169200.0
2012-06-18 10:00:00	AAPL	Stock	20.6196	20.8525	20.5968	20.8396	55933500.0
2012-06-18 10:30:00	AAPL	Stock	20.8364	20.8429	20.7679	20.7957	35929348.0
2012-06-18 11:00:00	AAPL	Stock	20.7989	20.8025	20.7321	20.7761	24489024.0
2012-06-18 11:30:00	AAPL	Stock	20.7779	20.8357	20.775	20.8164	24691856.0
2012-06-18 12:00:00	AAPL	Stock	20.8193	20.8211	20.7793	20.7857	14177436.0
2012-06-18 12:30:00	AAPL	Stock	20.7857	20.8304	20.7794	20.8157	11900252.0
2012-06-18 13:00:00	AAPL	Stock	20.8157	20.8571	20.8036	20.8499	17202724.0
2012-06-18 13:30:00	AAPL	Stock	20.8507	20.9275	20.8411	20.9275	27582184.0
2012-06-18 14:00:00	AAPL	Stock	20.9279	20.9961	20.9054	20.9632	39293548.0
2012-06-18 14:30:00	AAPL	Stock	20.9632	20.9918	20.8893	20.9379	30052484.0
2012-06-18 15:00:00	AAPL	Stock	20.9373	20.9689	20.8771	20.9586	29558648.0
2012-06-18 15:30:00	AAPL	Stock	20.9595	20.9682	20.8957	20.9218	41939576.0
2012-06-18 16:00:00	AAPL	Stock	20.9218	20.9454	20.4913	20.9207	11210668.0
2012-06-18 16:30:00	AAPL	Stock	20.9207	20.9621	20.6648	20.9268	626052.0
2012-06-18 17:00:00	AAPL	Stock	20.9268	20.95	20.9268	20.9393	456344.0
2012-06-18 17:30:00	AAPL	Stock	20.9386	20.9457	20.9386	20.9446	52052.0
2012-06-18 18:00:00	AAPL	Stock	20.9429	20.9446	20.925	20.925	71400.0
2012-06-18 18:30:00	AAPL	Stock	20.925	20.94	20.9214	20.9321	111664.0
2012-06-18 19:00:00	AAPL	Stock	20.9304	20.9436	20.93	20.9411	70252.0
2012-06-18 19:30:00	AAPL	Stock	20.9411	20.95	20.9214	20.9286	402472.0
2012-06-18 04:00:00	MSFT	Stock	30.99	30.99	30.06	30.06	1090.0
2012-06-18 04:30:00	MSFT	Stock	30.05	30.05	30.05	30.05	200.0
2012-06-18 06:30:00	MSFT	Stock	30.05	30.05	30.05	30.05	700.0
2012-06-18 07:00:00	MSFT	Stock	30.16	30.16	30.0	30.0	6836.0
2012-06-18 07:30:00	MSFT	Stock	30.14	30.15	30.0	30.08	5765.0
2012-06-18 08:00:00	MSFT	Stock	30.08	30.14	30.01	30.04	44898.0
2012-06-18 08:30:00	MSFT	Stock	30.03	30.03	29.95	29.98	53570.0
2012-06-18 09:00:00	MSFT	Stock	30.0	30.03	29.96	29.99	156103.0
2012-06-18 09:30:00	MSFT	Stock	29.99	30.02	29.71	29.82	6189802.0
2012-06-18 10:00:00	MSFT	Stock	29.82	29.98	29.79	29.925	5630509.0
2012-06-18 10:30:00	MSFT	Stock	29.925	30.03	29.87	29.945	5783056.0
2012-06-18 11:00:00	MSFT	Stock	29.97	30.02	29.89	29.895	4185736.0
2012-06-18 11:30:00	MSFT	Stock	29.892	29.9	29.8	29.868	3732135.0
2012-06-18 12:00:00	MSFT	Stock	29.86	29.86	29.775	29.795	1837618.0
2012-06-18 12:30:00	MSFT	Stock	29.8	29.84	29.75	29.78	2740270.0
2012-06-18 13:00:00	MSFT	Stock	29.785	29.87	29.728	29.856	3176275.0
2012-06-18 13:30:00	MSFT	Stock	29.86	29.87	29.82	29.845	1594098.0
2012-06-18 14:00:00	MSFT	Stock	29.85	29.89	29.84	29.867	2274734.0
2012-06-18 14:30:00	MSFT	Stock	29.87	29.88	29.79	29.815	2426096.0
2012-06-18 15:00:00	MSFT	Stock	29.817	29.84	29.72	29.78	3606337.0
2012-06-18 15:30:00	MSFT	Stock	29.775	29.84	29.73	29.84	7649756.0
2012-06-18 16:00:00	MSFT	Stock	29.84	30.0	29.79	29.87	6961157.0

> showing 50 of 76,023 rows — these rows as CSV

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