PREVIEW / stock_30min / 2012-01-12

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-01-12.parquet
  size:    1.4 MB
  rows:    74,822
  symbols: 3,528

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-12 05:30:00	AAPL	Stock	15.1554	15.1554	15.0957	15.0957	28840.0
2012-01-12 07:00:00	AAPL	Stock	15.1464	15.1818	15.1464	15.1779	230300.0
2012-01-12 07:30:00	AAPL	Stock	15.1696	15.1964	15.1607	15.18	226352.0
2012-01-12 08:00:00	AAPL	Stock	15.1789	15.1839	15.1429	15.1464	548128.0
2012-01-12 08:30:00	AAPL	Stock	15.1429	15.1432	15.0746	15.0864	1198204.0
2012-01-12 09:00:00	AAPL	Stock	15.0911	15.1143	15.0804	15.0889	515312.0
2012-01-12 09:30:00	AAPL	Stock	15.0889	15.1036	15.0082	15.0486	36413076.0
2012-01-12 10:00:00	AAPL	Stock	15.0468	15.0696	14.9857	15.0175	31500364.0
2012-01-12 10:30:00	AAPL	Stock	15.0175	15.0175	14.9554	14.9939	26358528.0
2012-01-12 11:00:00	AAPL	Stock	14.995	15.0271	14.9886	15.0157	11807264.0
2012-01-12 11:30:00	AAPL	Stock	15.0154	15.0407	15.0021	15.0186	9367428.0
2012-01-12 12:00:00	AAPL	Stock	15.0193	15.0429	15.0104	15.0239	7472948.0
2012-01-12 12:30:00	AAPL	Stock	15.0229	15.0532	15.0171	15.0496	8930152.0
2012-01-12 13:00:00	AAPL	Stock	15.0489	15.0643	15.0446	15.0482	8288000.0
2012-01-12 13:30:00	AAPL	Stock	15.0482	15.0589	15.0264	15.0529	8167376.0
2012-01-12 14:00:00	AAPL	Stock	15.0529	15.0679	15.0379	15.0561	8744400.0
2012-01-12 14:30:00	AAPL	Stock	15.0567	15.0829	15.0536	15.0696	10938200.0
2012-01-12 15:00:00	AAPL	Stock	15.0687	15.0696	15.0361	15.0557	9769844.0
2012-01-12 15:30:00	AAPL	Stock	15.0539	15.0621	15.0407	15.0472	17902500.0
2012-01-12 16:00:00	AAPL	Stock	15.0468	15.0646	15.0332	15.0507	9303616.0
2012-01-12 16:30:00	AAPL	Stock	15.0496	15.0571	15.0496	15.0571	326200.0
2012-01-12 17:00:00	AAPL	Stock	15.0229	15.0568	15.0229	15.05	115920.0
2012-01-12 17:30:00	AAPL	Stock	15.05	15.05	15.0429	15.05	55440.0
2012-01-12 18:00:00	AAPL	Stock	15.055	15.0554	15.0496	15.0496	28840.0
2012-01-12 18:30:00	AAPL	Stock	15.0554	15.0554	15.0521	15.0554	9380.0
2012-01-12 19:00:00	AAPL	Stock	15.0554	15.0571	15.0554	15.0571	33152.0
2012-01-12 19:30:00	AAPL	Stock	15.0614	15.0661	15.0554	15.0661	96180.0
2012-01-12 08:00:00	MSFT	Stock	27.95	27.95	27.86	27.9	3450.0
2012-01-12 08:30:00	MSFT	Stock	27.8	27.82	27.7	27.7	33065.0
2012-01-12 09:00:00	MSFT	Stock	27.73	27.88	27.7	27.86	20619.0
2012-01-12 09:30:00	MSFT	Stock	27.87	27.96	27.77	27.87	5444012.0
2012-01-12 10:00:00	MSFT	Stock	27.87	27.925	27.72	27.763	5393339.0
2012-01-12 10:30:00	MSFT	Stock	27.76	27.82	27.645	27.769	4278598.0
2012-01-12 11:00:00	MSFT	Stock	27.765	27.818	27.74	27.8	2157917.0
2012-01-12 11:30:00	MSFT	Stock	27.8	27.81	27.74	27.79	2231246.0
2012-01-12 12:00:00	MSFT	Stock	27.785	27.855	27.78	27.84	2558399.0
2012-01-12 12:30:00	MSFT	Stock	27.84	27.91	27.84	27.906	2224458.0
2012-01-12 13:00:00	MSFT	Stock	27.9	27.95	27.88	27.91	2735100.0
2012-01-12 13:30:00	MSFT	Stock	27.906	27.93	27.855	27.906	1513465.0
2012-01-12 14:00:00	MSFT	Stock	27.9	27.91	27.86	27.893	1314011.0
2012-01-12 14:30:00	MSFT	Stock	27.89	27.95	27.89	27.935	2129480.0
2012-01-12 15:00:00	MSFT	Stock	27.935	27.99	27.93	27.97	2161717.0
2012-01-12 15:30:00	MSFT	Stock	27.98	28.02	27.94	28.0	6897368.0
2012-01-12 16:00:00	MSFT	Stock	28.0	28.01	27.84	28.0	2078722.0
2012-01-12 16:30:00	MSFT	Stock	28.0	28.04	27.97	28.0	127914.0
2012-01-12 17:00:00	MSFT	Stock	27.809	28.0	27.809	28.0	4400.0
2012-01-12 17:30:00	MSFT	Stock	28.0	28.0	27.97	27.97	4500.0
2012-01-12 18:00:00	MSFT	Stock	27.99	28.0	27.98	27.99	3002.0
2012-01-12 18:30:00	MSFT	Stock	28.0	28.0	28.0	28.0	1925.0
2012-01-12 19:00:00	MSFT	Stock	28.0	28.0	28.0	28.0	1296.0

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

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