PREVIEW / stock_30min / 2010-05-28

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-05-28.parquet
  size:    1.3 MB
  rows:    72,403
  symbols: 3,462

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
2010-05-28 04:00:00	AAPL	Stock	9.1468	9.1468	9.1468	9.1468	14000.0
2010-05-28 04:30:00	AAPL	Stock	9.1618	9.1879	9.1618	9.1857	8400.0
2010-05-28 06:00:00	AAPL	Stock	9.1857	9.2075	9.1786	9.1821	53200.0
2010-05-28 06:30:00	AAPL	Stock	9.1821	9.1821	9.1689	9.1689	98196.0
2010-05-28 07:00:00	AAPL	Stock	9.1693	9.2132	9.1693	9.2036	641088.0
2010-05-28 07:30:00	AAPL	Stock	9.1939	9.225	9.1796	9.2075	610260.0
2010-05-28 08:00:00	AAPL	Stock	9.2125	9.2768	9.1996	9.2679	8040872.0
2010-05-28 08:30:00	AAPL	Stock	9.2636	9.2636	9.2321	9.2461	4829356.0
2010-05-28 09:00:00	AAPL	Stock	9.2479	9.2632	9.2357	9.2625	4099312.0
2010-05-28 09:30:00	AAPL	Stock	9.26	9.2643	9.15	9.208	129985268.0
2010-05-28 10:00:00	AAPL	Stock	9.2107	9.2318	9.1964	9.1982	53765656.0
2010-05-28 10:30:00	AAPL	Stock	9.1993	9.2196	9.1344	9.1529	53041408.0
2010-05-28 11:00:00	AAPL	Stock	9.1525	9.1725	9.0814	9.1125	67879112.0
2010-05-28 11:30:00	AAPL	Stock	9.1121	9.1311	9.1016	9.1218	39225592.0
2010-05-28 12:00:00	AAPL	Stock	9.1225	9.1629	9.1143	9.1596	30214604.0
2010-05-28 12:30:00	AAPL	Stock	9.1601	9.1611	9.0482	9.1021	79758056.0
2010-05-28 13:00:00	AAPL	Stock	9.1032	9.1357	9.0904	9.1164	30910124.0
2010-05-28 13:30:00	AAPL	Stock	9.1168	9.1236	9.085	9.0996	24590832.0
2010-05-28 14:00:00	AAPL	Stock	9.095	9.1382	9.0571	9.1343	40321484.0
2010-05-28 14:30:00	AAPL	Stock	9.1357	9.2143	9.1246	9.1846	63595700.0
2010-05-28 15:00:00	AAPL	Stock	9.1847	9.2446	9.1679	9.2393	52517948.0
2010-05-28 15:30:00	AAPL	Stock	9.2396	9.25	9.1693	9.1782	105817348.0
2010-05-28 16:00:00	AAPL	Stock	9.1782	9.2091	9.1211	9.1839	18494084.0
2010-05-28 16:30:00	AAPL	Stock	9.1852	9.2437	9.1503	9.1821	1119944.0
2010-05-28 17:00:00	AAPL	Stock	9.1821	9.1839	9.1793	9.1818	292124.0
2010-05-28 17:30:00	AAPL	Stock	9.1818	9.1861	9.1743	9.1829	211484.0
2010-05-28 18:00:00	AAPL	Stock	9.1836	9.1939	9.1743	9.1875	212660.0
2010-05-28 18:30:00	AAPL	Stock	9.1893	9.1982	9.1882	9.1982	139468.0
2010-05-28 19:00:00	AAPL	Stock	9.1968	9.1993	9.1843	9.1843	247156.0
2010-05-28 19:30:00	AAPL	Stock	9.1829	9.1893	9.1746	9.1761	216384.0
2010-05-28 05:00:00	MSFT	Stock	26.13	26.13	26.02	26.02	450.0
2010-05-28 06:30:00	MSFT	Stock	26.04	26.04	26.04	26.04	200.0
2010-05-28 07:30:00	MSFT	Stock	26.09	26.11	26.09	26.11	1600.0
2010-05-28 08:00:00	MSFT	Stock	26.04	26.1	26.0	26.0	16682.0
2010-05-28 08:30:00	MSFT	Stock	26.01	26.03	25.9	25.97	13987.0
2010-05-28 09:00:00	MSFT	Stock	25.94	25.95	25.78	25.83	104093.0
2010-05-28 09:30:00	MSFT	Stock	25.84	25.9	25.68	25.798	9302482.0
2010-05-28 10:00:00	MSFT	Stock	25.8	25.88	25.74	25.76	4412911.0
2010-05-28 10:30:00	MSFT	Stock	25.77	25.85	25.7	25.82	5003505.0
2010-05-28 11:00:00	MSFT	Stock	25.82	25.94	25.73	25.804	5211646.0
2010-05-28 11:30:00	MSFT	Stock	25.802	25.81	25.7	25.762	3307601.0
2010-05-28 12:00:00	MSFT	Stock	25.77	25.9	25.722	25.89	3158234.0
2010-05-28 12:30:00	MSFT	Stock	25.89	25.9	25.66	25.75	6649554.0
2010-05-28 13:00:00	MSFT	Stock	25.76	25.79	25.7	25.72	2374822.0
2010-05-28 13:30:00	MSFT	Stock	25.73	25.8	25.72	25.75	2261746.0
2010-05-28 14:00:00	MSFT	Stock	25.75	25.83	25.68	25.815	2602299.0
2010-05-28 14:30:00	MSFT	Stock	25.816	25.95	25.77	25.88	3416784.0
2010-05-28 15:00:00	MSFT	Stock	25.88	26.05	25.87	26.04	3804772.0
2010-05-28 15:30:00	MSFT	Stock	26.05	26.12	25.76	25.8	8752209.0
2010-05-28 16:00:00	MSFT	Stock	25.81	25.945	25.72	25.8	4748921.0

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

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