PREVIEW / stock_30min / 2012-01-10

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-01-10.parquet
  size:    1.4 MB
  rows:    76,508
  symbols: 3,538

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-10 04:00:00	AAPL	Stock	15.1264	15.1821	15.1264	15.1714	61600.0
2012-01-10 04:30:00	AAPL	Stock	15.1821	15.1857	15.1821	15.1821	44800.0
2012-01-10 05:00:00	AAPL	Stock	15.1857	15.1857	15.1857	15.1857	8400.0
2012-01-10 05:30:00	AAPL	Stock	15.2136	15.2136	15.2136	15.2136	14000.0
2012-01-10 06:00:00	AAPL	Stock	15.2036	15.2036	15.2036	15.2036	2800.0
2012-01-10 06:30:00	AAPL	Stock	15.1786	15.1786	15.1786	15.1786	2800.0
2012-01-10 07:00:00	AAPL	Stock	15.1786	15.2125	15.1607	15.1914	324156.0
2012-01-10 07:30:00	AAPL	Stock	15.2075	15.2268	15.2	15.2	404264.0
2012-01-10 08:00:00	AAPL	Stock	15.2054	15.2229	15.1786	15.2143	1064476.0
2012-01-10 08:30:00	AAPL	Stock	15.2139	15.2182	15.1964	15.2043	830676.0
2012-01-10 09:00:00	AAPL	Stock	15.2039	15.2275	15.2018	15.2139	1556940.0
2012-01-10 09:30:00	AAPL	Stock	15.2114	15.2143	15.1286	15.1575	46681964.0
2012-01-10 10:00:00	AAPL	Stock	15.1604	15.1993	15.1371	15.1525	29475236.0
2012-01-10 10:30:00	AAPL	Stock	15.1534	15.175	15.1379	15.1618	18775624.0
2012-01-10 11:00:00	AAPL	Stock	15.162	15.1771	15.1554	15.1631	13564460.0
2012-01-10 11:30:00	AAPL	Stock	15.1618	15.1736	15.1186	15.12	12181764.0
2012-01-10 12:00:00	AAPL	Stock	15.1186	15.1332	15.0536	15.0721	22561448.0
2012-01-10 12:30:00	AAPL	Stock	15.0721	15.0779	15.0564	15.0754	19569088.0
2012-01-10 13:00:00	AAPL	Stock	15.075	15.0961	15.0593	15.0664	11331740.0
2012-01-10 13:30:00	AAPL	Stock	15.0678	15.1389	15.0646	15.1132	15280216.0
2012-01-10 14:00:00	AAPL	Stock	15.1132	15.1382	15.1025	15.1189	9281048.0
2012-01-10 14:30:00	AAPL	Stock	15.1189	15.1264	15.1043	15.1257	8748768.0
2012-01-10 15:00:00	AAPL	Stock	15.1264	15.1418	15.1179	15.12	10244836.0
2012-01-10 15:30:00	AAPL	Stock	15.1196	15.1268	15.0929	15.1154	24320016.0
2012-01-10 16:00:00	AAPL	Stock	15.1099	15.1729	15.0971	15.1071	7837144.0
2012-01-10 16:30:00	AAPL	Stock	15.1071	15.1181	15.0939	15.1157	1221052.0
2012-01-10 17:00:00	AAPL	Stock	15.1018	15.1018	15.0893	15.0925	93436.0
2012-01-10 17:30:00	AAPL	Stock	15.0914	15.0971	15.0914	15.0971	23296.0
2012-01-10 18:00:00	AAPL	Stock	15.0929	15.1157	15.0839	15.0982	251440.0
2012-01-10 18:30:00	AAPL	Stock	15.0921	15.0971	15.0911	15.0971	10668.0
2012-01-10 19:00:00	AAPL	Stock	15.0911	15.0911	15.0807	15.0893	50400.0
2012-01-10 19:30:00	AAPL	Stock	15.0804	15.0821	15.0686	15.0721	84672.0
2012-01-10 05:30:00	MSFT	Stock	28.02	28.02	28.02	28.02	300.0
2012-01-10 07:00:00	MSFT	Stock	28.0	28.05	27.86	27.9	10650.0
2012-01-10 07:30:00	MSFT	Stock	28.0	28.03	27.94	28.0	5708.0
2012-01-10 08:00:00	MSFT	Stock	27.95	28.0	27.92	27.95	31285.0
2012-01-10 08:30:00	MSFT	Stock	27.92	27.97	27.9	27.93	84191.0
2012-01-10 09:00:00	MSFT	Stock	27.93	27.95	27.9	27.93	69991.0
2012-01-10 09:30:00	MSFT	Stock	27.94	28.0	27.82	27.975	10002038.0
2012-01-10 10:00:00	MSFT	Stock	27.97	28.09	27.97	28.05	7022066.0
2012-01-10 10:30:00	MSFT	Stock	28.05	28.15	27.93	28.0	5892639.0
2012-01-10 11:00:00	MSFT	Stock	27.99	28.05	27.92	28.03	3893210.0
2012-01-10 11:30:00	MSFT	Stock	28.03	28.09	27.99	28.06	2593390.0
2012-01-10 12:00:00	MSFT	Stock	28.055	28.06	27.95	27.956	1993591.0
2012-01-10 12:30:00	MSFT	Stock	27.955	28.0	27.95	27.99	1484078.0
2012-01-10 13:00:00	MSFT	Stock	27.99	27.99	27.92	27.93	1469457.0
2012-01-10 13:30:00	MSFT	Stock	27.92	27.97	27.9	27.916	1931547.0
2012-01-10 14:00:00	MSFT	Stock	27.913	27.94	27.88	27.882	2153731.0
2012-01-10 14:30:00	MSFT	Stock	27.885	28.0	27.87	27.98	3275632.0
2012-01-10 15:00:00	MSFT	Stock	27.99	28.0	27.84	27.843	2996543.0

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

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