PREVIEW / stock_30min / 2009-03-03

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-03-03.parquet
  size:    1.3 MB
  rows:    72,115
  symbols: 3,359

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
2009-03-03 07:30:00	AAPL	Stock	3.1679	3.1679	3.1679	3.1679	5600.0
2009-03-03 08:00:00	AAPL	Stock	3.1671	3.1839	3.15	3.1821	547596.0
2009-03-03 08:30:00	AAPL	Stock	3.1839	3.2071	3.1679	3.1821	2244368.0
2009-03-03 09:00:00	AAPL	Stock	3.1821	3.2036	3.175	3.1786	1414028.0
2009-03-03 09:30:00	AAPL	Stock	3.1768	3.1964	3.1536	3.1611	86571688.0
2009-03-03 10:00:00	AAPL	Stock	3.1611	3.1786	3.1386	3.1686	57542212.0
2009-03-03 10:30:00	AAPL	Stock	3.1693	3.1929	3.1507	3.1646	49810152.0
2009-03-03 11:00:00	AAPL	Stock	3.165	3.1886	3.1429	3.1871	52536764.0
2009-03-03 11:30:00	AAPL	Stock	3.1868	3.1868	3.15	3.17	37779980.0
2009-03-03 12:00:00	AAPL	Stock	3.1704	3.2118	3.1671	3.2096	44153508.0
2009-03-03 12:30:00	AAPL	Stock	3.21	3.2136	3.165	3.1686	44414748.0
2009-03-03 13:00:00	AAPL	Stock	3.1689	3.1929	3.1564	3.1675	39607736.0
2009-03-03 13:30:00	AAPL	Stock	3.1671	3.1882	3.155	3.185	40374404.0
2009-03-03 14:00:00	AAPL	Stock	3.185	3.2282	3.1807	3.2254	54625032.0
2009-03-03 14:30:00	AAPL	Stock	3.2254	3.2407	3.2057	3.225	60397456.0
2009-03-03 15:00:00	AAPL	Stock	3.225	3.2254	3.1743	3.1771	58806888.0
2009-03-03 15:30:00	AAPL	Stock	3.1771	3.1961	3.1539	3.1557	72280404.0
2009-03-03 16:00:00	AAPL	Stock	3.1557	3.1928	3.1404	3.1432	12459776.0
2009-03-03 16:30:00	AAPL	Stock	3.1432	3.1432	3.1161	3.1386	812448.0
2009-03-03 17:00:00	AAPL	Stock	3.1321	3.1561	3.1257	3.1336	2054052.0
2009-03-03 17:30:00	AAPL	Stock	3.1561	3.1561	3.1286	3.1293	376964.0
2009-03-03 18:00:00	AAPL	Stock	3.1286	3.1804	3.1286	3.1332	2718716.0
2009-03-03 18:30:00	AAPL	Stock	3.1357	3.1386	3.1286	3.1286	126252.0
2009-03-03 19:00:00	AAPL	Stock	3.1321	3.1321	3.1289	3.1314	17780.0
2009-03-03 19:30:00	AAPL	Stock	3.1314	3.1318	3.125	3.1318	40964.0
2009-03-03 20:00:00	AAPL	Stock	3.155	3.155	3.155	3.155	221200.0
2009-03-03 06:00:00	MSFT	Stock	15.81	15.81	15.81	15.81	1000.0
2009-03-03 06:30:00	MSFT	Stock	15.8	15.8	15.8	15.8	500.0
2009-03-03 07:00:00	MSFT	Stock	15.77	15.9	15.77	15.9	450.0
2009-03-03 07:30:00	MSFT	Stock	15.9	16.0	15.9	15.9	11022.0
2009-03-03 08:00:00	MSFT	Stock	15.9	15.9	15.85	15.88	84996.0
2009-03-03 08:30:00	MSFT	Stock	15.89	16.0	15.88	15.96	54922.0
2009-03-03 09:00:00	MSFT	Stock	15.96	16.15	15.95	15.95	127986.0
2009-03-03 09:30:00	MSFT	Stock	15.95	16.23	15.95	16.08	7569259.0
2009-03-03 10:00:00	MSFT	Stock	16.08	16.15	15.99	16.062	5313144.0
2009-03-03 10:30:00	MSFT	Stock	16.06	16.08	15.9	15.97	4386063.0
2009-03-03 11:00:00	MSFT	Stock	15.97	15.98	15.71	15.801	7397910.0
2009-03-03 11:30:00	MSFT	Stock	15.81	15.85	15.64	15.71	5409338.0
2009-03-03 12:00:00	MSFT	Stock	15.71	16.05	15.71	15.98	5516558.0
2009-03-03 12:30:00	MSFT	Stock	15.98	16.0	15.83	15.85	3585606.0
2009-03-03 13:00:00	MSFT	Stock	15.85	16.0	15.77	15.86	3922751.0
2009-03-03 13:30:00	MSFT	Stock	15.86	15.99	15.79	15.96	3087467.0
2009-03-03 14:00:00	MSFT	Stock	15.96	16.09	15.93	16.07	4217802.0
2009-03-03 14:30:00	MSFT	Stock	16.06	16.24	16.06	16.19	6972319.0
2009-03-03 15:00:00	MSFT	Stock	16.18	16.19	15.97	15.99	5930511.0
2009-03-03 15:30:00	MSFT	Stock	16.0	16.235	15.89	15.9	9246907.0
2009-03-03 16:00:00	MSFT	Stock	15.89	16.064	15.666	15.85	4834934.0
2009-03-03 16:30:00	MSFT	Stock	15.969	15.969	15.66	15.7	74354.0
2009-03-03 17:00:00	MSFT	Stock	15.79	15.88	15.71	15.71	166869.0
2009-03-03 17:30:00	MSFT	Stock	15.74	15.88	15.72	15.75	99711.0

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

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