PREVIEW / stock_30min / 2007-01-19

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-01-19.parquet
  size:    964 KB
  rows:    52,172
  symbols: 2,500

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
2007-01-19 04:00:00	AAPL	Stock	3.1775	3.1775	3.1775	3.1775	2800.0
2007-01-19 04:30:00	AAPL	Stock	3.1775	3.1818	3.1775	3.1818	11200.0
2007-01-19 07:00:00	AAPL	Stock	3.1689	3.175	3.1679	3.1689	1094604.0
2007-01-19 07:30:00	AAPL	Stock	3.1689	3.1689	3.1618	3.1643	626640.0
2007-01-19 08:00:00	AAPL	Stock	3.1661	3.1679	3.1529	3.1636	5475428.0
2007-01-19 08:30:00	AAPL	Stock	3.1629	3.1714	3.1607	3.1643	4421480.0
2007-01-19 09:00:00	AAPL	Stock	3.1643	3.1714	3.1625	3.1629	4897732.0
2007-01-19 09:30:00	AAPL	Stock	3.165	3.1954	3.1471	3.1646	230515180.0
2007-01-19 10:00:00	AAPL	Stock	3.1646	3.1768	3.155	3.1764	162367828.0
2007-01-19 10:30:00	AAPL	Stock	3.1764	3.1943	3.1696	3.1707	151844980.0
2007-01-19 11:00:00	AAPL	Stock	3.1707	3.1786	3.1579	3.1629	110050024.0
2007-01-19 11:30:00	AAPL	Stock	3.1629	3.1711	3.1571	3.1632	53729648.0
2007-01-19 12:00:00	AAPL	Stock	3.1636	3.1786	3.1543	3.1693	87046848.0
2007-01-19 12:30:00	AAPL	Stock	3.1689	3.1804	3.1668	3.1771	45340764.0
2007-01-19 13:00:00	AAPL	Stock	3.1771	3.2011	3.1764	3.1982	90145412.0
2007-01-19 13:30:00	AAPL	Stock	3.1982	3.1982	3.1821	3.1946	63814436.0
2007-01-19 14:00:00	AAPL	Stock	3.1946	3.2018	3.19	3.1921	68975284.0
2007-01-19 14:30:00	AAPL	Stock	3.1918	3.1975	3.1843	3.1871	59667020.0
2007-01-19 15:00:00	AAPL	Stock	3.1868	3.1875	3.1696	3.1711	81157160.0
2007-01-19 15:30:00	AAPL	Stock	3.1711	3.1768	3.155	3.1604	115669204.0
2007-01-19 16:00:00	AAPL	Stock	3.1607	3.1679	3.1575	3.1679	2558304.0
2007-01-19 16:30:00	AAPL	Stock	3.1661	3.1679	3.1625	3.1625	175924.0
2007-01-19 17:00:00	AAPL	Stock	3.1643	3.1643	3.1593	3.1593	344512.0
2007-01-19 17:30:00	AAPL	Stock	3.1607	3.1625	3.1589	3.1625	211624.0
2007-01-19 18:00:00	AAPL	Stock	3.1621	3.1621	3.1607	3.1621	67788.0
2007-01-19 18:30:00	AAPL	Stock	3.1611	3.1625	3.1607	3.1607	77980.0
2007-01-19 19:00:00	AAPL	Stock	3.1611	3.1636	3.1607	3.1618	135744.0
2007-01-19 19:30:00	AAPL	Stock	3.1621	3.1679	3.1621	3.1629	235928.0
2007-01-19 08:00:00	MSFT	Stock	30.8	30.81	30.76	30.81	3671.0
2007-01-19 08:30:00	MSFT	Stock	30.81	30.81	30.75	30.76	108834.0
2007-01-19 09:00:00	MSFT	Stock	30.75	30.88	30.72	30.72	535751.0
2007-01-19 09:30:00	MSFT	Stock	30.73	30.98	30.69	30.86	11635048.0
2007-01-19 10:00:00	MSFT	Stock	30.87	30.96	30.79	30.84	4814568.0
2007-01-19 10:30:00	MSFT	Stock	30.84	30.85	30.79	30.823	6924932.0
2007-01-19 11:00:00	MSFT	Stock	30.82	30.89	30.81	30.85	5265620.0
2007-01-19 11:30:00	MSFT	Stock	30.85	30.9	30.82	30.88	4415291.0
2007-01-19 12:00:00	MSFT	Stock	30.87	30.95	30.85	30.89	4358308.0
2007-01-19 12:30:00	MSFT	Stock	30.88	30.91	30.83	30.87	2715645.0
2007-01-19 13:00:00	MSFT	Stock	30.87	30.94	30.87	30.92	3355153.0
2007-01-19 13:30:00	MSFT	Stock	30.92	30.96	30.91	30.96	2769735.0
2007-01-19 14:00:00	MSFT	Stock	30.95	30.97	30.91	30.94	2508079.0
2007-01-19 14:30:00	MSFT	Stock	30.93	31.09	30.93	31.04	7903476.0
2007-01-19 15:00:00	MSFT	Stock	31.04	31.06	30.96	31.04	7626480.0
2007-01-19 15:30:00	MSFT	Stock	31.04	31.11	30.99	31.09	7697095.0
2007-01-19 16:00:00	MSFT	Stock	31.09	31.12	30.998	30.998	285579.0
2007-01-19 16:30:00	MSFT	Stock	31.08	31.09	31.04	31.09	31377.0
2007-01-19 17:00:00	MSFT	Stock	31.09	31.1	31.09	31.1	4200.0
2007-01-19 17:30:00	MSFT	Stock	31.06	31.06	31.06	31.06	1000.0
2007-01-19 18:00:00	MSFT	Stock	31.07	31.1	31.07	31.1	1200.0
2007-01-19 18:30:00	MSFT	Stock	31.1	31.1	31.06	31.06	200.0

> showing 50 of 52,172 rows — these rows as CSV

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