PREVIEW / stock_30min / 2007-03-19

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-03-19.parquet
  size:    1.0 MB
  rows:    56,327
  symbols: 2,565

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-03-19 04:30:00	AAPL	Stock	3.2125	3.2125	3.2125	3.2125	2800.0
2007-03-19 07:00:00	AAPL	Stock	3.2175	3.2293	3.2143	3.2293	86800.0
2007-03-19 07:30:00	AAPL	Stock	3.2296	3.2493	3.2293	3.2454	1192800.0
2007-03-19 08:00:00	AAPL	Stock	3.2464	3.25	3.2318	3.2321	2201696.0
2007-03-19 08:30:00	AAPL	Stock	3.2318	3.2318	3.2261	3.2286	743932.0
2007-03-19 09:00:00	AAPL	Stock	3.2286	3.2304	3.2189	3.2218	3895808.0
2007-03-19 09:30:00	AAPL	Stock	3.2229	3.2257	3.1996	3.2211	92645476.0
2007-03-19 10:00:00	AAPL	Stock	3.2207	3.2218	3.2104	3.2193	42054404.0
2007-03-19 10:30:00	AAPL	Stock	3.2193	3.2371	3.2111	3.2339	64910664.0
2007-03-19 11:00:00	AAPL	Stock	3.2339	3.2589	3.2329	3.2557	100281860.0
2007-03-19 11:30:00	AAPL	Stock	3.2564	3.2696	3.2525	3.2654	72531676.0
2007-03-19 12:00:00	AAPL	Stock	3.2657	3.2696	3.25	3.2539	49270592.0
2007-03-19 12:30:00	AAPL	Stock	3.2543	3.2582	3.2518	3.2543	26173168.0
2007-03-19 13:00:00	AAPL	Stock	3.2543	3.2607	3.2489	3.2579	33891396.0
2007-03-19 13:30:00	AAPL	Stock	3.2579	3.268	3.2554	3.2617	48204604.0
2007-03-19 14:00:00	AAPL	Stock	3.2614	3.2632	3.2571	3.2575	27717816.0
2007-03-19 14:30:00	AAPL	Stock	3.2575	3.2596	3.2525	3.2564	30489536.0
2007-03-19 15:00:00	AAPL	Stock	3.2564	3.2579	3.2432	3.2446	40318404.0
2007-03-19 15:30:00	AAPL	Stock	3.2439	3.255	3.2357	3.255	66128104.0
2007-03-19 16:00:00	AAPL	Stock	3.255	3.2589	3.2536	3.2571	4047288.0
2007-03-19 16:30:00	AAPL	Stock	3.2571	3.2582	3.2571	3.2582	163800.0
2007-03-19 17:00:00	AAPL	Stock	3.2579	3.2582	3.2579	3.2579	61376.0
2007-03-19 17:30:00	AAPL	Stock	3.2579	3.2589	3.2564	3.2579	149576.0
2007-03-19 18:00:00	AAPL	Stock	3.2568	3.2589	3.2568	3.2589	39200.0
2007-03-19 18:30:00	AAPL	Stock	3.2575	3.2575	3.2575	3.2575	5600.0
2007-03-19 19:00:00	AAPL	Stock	3.2579	3.2589	3.2564	3.2568	77028.0
2007-03-19 19:30:00	AAPL	Stock	3.2571	3.2589	3.2571	3.2589	123648.0
2007-03-19 07:00:00	MSFT	Stock	27.44	27.44	27.33	27.33	300.0
2007-03-19 08:00:00	MSFT	Stock	27.4	27.43	27.32	27.35	26424.0
2007-03-19 08:30:00	MSFT	Stock	27.37	27.43	27.37	27.4	1400.0
2007-03-19 09:00:00	MSFT	Stock	27.4	27.4	27.33	27.33	25270.0
2007-03-19 09:30:00	MSFT	Stock	27.34	27.55	27.32	27.53	7086060.0
2007-03-19 10:00:00	MSFT	Stock	27.54	27.63	27.44	27.63	3315095.0
2007-03-19 10:30:00	MSFT	Stock	27.64	27.72	27.55	27.68	3655328.0
2007-03-19 11:00:00	MSFT	Stock	27.67	27.79	27.63	27.75	2715273.0
2007-03-19 11:30:00	MSFT	Stock	27.76	27.8	27.72	27.78	2288445.0
2007-03-19 12:00:00	MSFT	Stock	27.79	27.79	27.7	27.75	1963641.0
2007-03-19 12:30:00	MSFT	Stock	27.76	27.77	27.68	27.74	1920534.0
2007-03-19 13:00:00	MSFT	Stock	27.74	27.77	27.67	27.74	1695135.0
2007-03-19 13:30:00	MSFT	Stock	27.74	27.82	27.7	27.82	2083342.0
2007-03-19 14:00:00	MSFT	Stock	27.82	27.82	27.78	27.78	1757514.0
2007-03-19 14:30:00	MSFT	Stock	27.79	27.83	27.76	27.78	2034381.0
2007-03-19 15:00:00	MSFT	Stock	27.78	27.78	27.6	27.7	3419132.0
2007-03-19 15:30:00	MSFT	Stock	27.71	27.83	27.669	27.83	9749886.0
2007-03-19 16:00:00	MSFT	Stock	27.82	27.85	27.82	27.82	645690.0
2007-03-19 16:30:00	MSFT	Stock	27.83	27.84	27.709	27.84	535453.0
2007-03-19 17:00:00	MSFT	Stock	27.83	27.85	27.83	27.85	939200.0
2007-03-19 17:30:00	MSFT	Stock	27.84	27.84	27.84	27.84	200.0
2007-03-19 18:00:00	MSFT	Stock	27.84	27.84	27.83	27.83	3650.0
2007-03-19 18:30:00	MSFT	Stock	27.84	27.84	27.84	27.84	100.0

> showing 50 of 56,327 rows — these rows as CSV

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