PREVIEW / stock_30min / 2007-01-18

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-01-18.parquet
  size:    1000 KB
  rows:    54,116
  symbols: 2,490

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-18 04:00:00	AAPL	Stock	3.3604	3.3604	3.3471	3.3518	364000.0
2007-01-18 04:30:00	AAPL	Stock	3.3511	3.3564	3.3511	3.3536	336000.0
2007-01-18 05:00:00	AAPL	Stock	3.3507	3.3536	3.3468	3.3471	205380.0
2007-01-18 05:30:00	AAPL	Stock	3.3468	3.3468	3.3429	3.3429	50400.0
2007-01-18 06:00:00	AAPL	Stock	3.3432	3.3432	3.325	3.3286	246120.0
2007-01-18 06:30:00	AAPL	Stock	3.3286	3.3339	3.3161	3.3339	294000.0
2007-01-18 07:00:00	AAPL	Stock	3.3354	3.3518	3.3286	3.3518	2151464.0
2007-01-18 07:30:00	AAPL	Stock	3.3518	3.3543	3.3232	3.325	5812184.0
2007-01-18 08:00:00	AAPL	Stock	3.3286	3.3393	3.305	3.3282	37133068.0
2007-01-18 08:30:00	AAPL	Stock	3.3279	3.3304	3.3193	3.3268	15395464.0
2007-01-18 09:00:00	AAPL	Stock	3.3271	3.3314	3.2771	3.2886	56245028.0
2007-01-18 09:30:00	AAPL	Stock	3.2893	3.2896	3.2232	3.2289	556373412.0
2007-01-18 10:00:00	AAPL	Stock	3.2296	3.2464	3.1918	3.2346	385607712.0
2007-01-18 10:30:00	AAPL	Stock	3.2346	3.2379	3.2164	3.2314	159929420.0
2007-01-18 11:00:00	AAPL	Stock	3.2314	3.2679	3.23	3.2579	221470368.0
2007-01-18 11:30:00	AAPL	Stock	3.2579	3.2654	3.2468	3.2543	101083248.0
2007-01-18 12:00:00	AAPL	Stock	3.2546	3.2614	3.2293	3.2325	126183204.0
2007-01-18 12:30:00	AAPL	Stock	3.2325	3.2489	3.2282	3.2446	63393232.0
2007-01-18 13:00:00	AAPL	Stock	3.2443	3.25	3.2286	3.2296	57936284.0
2007-01-18 13:30:00	AAPL	Stock	3.2293	3.2382	3.2164	3.2175	76571992.0
2007-01-18 14:00:00	AAPL	Stock	3.2175	3.2643	3.2107	3.22	103969600.0
2007-01-18 14:30:00	AAPL	Stock	3.22	3.2225	3.1986	3.2054	114172744.0
2007-01-18 15:00:00	AAPL	Stock	3.2057	3.2161	3.1982	3.2132	96195652.0
2007-01-18 15:30:00	AAPL	Stock	3.2132	3.2136	3.1807	3.1811	161452816.0
2007-01-18 16:00:00	AAPL	Stock	3.1807	3.1839	3.1679	3.1696	8447936.0
2007-01-18 16:30:00	AAPL	Stock	3.1814	3.1814	3.1607	3.1614	2271360.0
2007-01-18 17:00:00	AAPL	Stock	3.1611	3.1664	3.1607	3.1654	1404816.0
2007-01-18 17:30:00	AAPL	Stock	3.1643	3.1661	3.1632	3.1661	474432.0
2007-01-18 18:00:00	AAPL	Stock	3.1671	3.1764	3.1661	3.1764	887656.0
2007-01-18 18:30:00	AAPL	Stock	3.1757	3.1779	3.165	3.1657	920612.0
2007-01-18 19:00:00	AAPL	Stock	3.1657	3.1679	3.1607	3.1643	413840.0
2007-01-18 19:30:00	AAPL	Stock	3.1686	3.1693	3.1639	3.1646	463456.0
2007-01-18 04:00:00	MSFT	Stock	31.1	31.1	31.1	31.1	2000.0
2007-01-18 07:30:00	MSFT	Stock	31.07	31.07	31.07	31.07	900.0
2007-01-18 08:00:00	MSFT	Stock	31.03	31.09	31.02	31.02	15735.0
2007-01-18 08:30:00	MSFT	Stock	31.02	31.09	31.02	31.03	14035.0
2007-01-18 09:00:00	MSFT	Stock	31.1	31.17	31.03	31.13	1132500.0
2007-01-18 09:30:00	MSFT	Stock	31.15	31.37	31.09	31.26	8112109.0
2007-01-18 10:00:00	MSFT	Stock	31.25	31.25	30.9	31.01	6126667.0
2007-01-18 10:30:00	MSFT	Stock	31.01	31.07	30.98	30.99	3005792.0
2007-01-18 11:00:00	MSFT	Stock	30.98	31.04	30.95	31.01	3836786.0
2007-01-18 11:30:00	MSFT	Stock	31.0	31.03	30.97	30.98	1705842.0
2007-01-18 12:00:00	MSFT	Stock	30.98	31.06	30.86	30.91	3445284.0
2007-01-18 12:30:00	MSFT	Stock	30.91	31.02	30.89	30.992	2778636.0
2007-01-18 13:00:00	MSFT	Stock	30.99	31.05	30.97	31.01	1636713.0
2007-01-18 13:30:00	MSFT	Stock	31.01	31.1	30.96	30.98	1655067.0
2007-01-18 14:00:00	MSFT	Stock	30.98	31.04	30.93	30.94	2583604.0
2007-01-18 14:30:00	MSFT	Stock	30.94	30.981	30.8	30.84	4739759.0
2007-01-18 15:00:00	MSFT	Stock	30.84	31.011	30.81	31.01	5499853.0
2007-01-18 15:30:00	MSFT	Stock	31.01	31.05	30.95	30.99	7061925.0

> showing 50 of 54,116 rows — these rows as CSV

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