PREVIEW / stock_30min / 2010-07-29

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-07-29.parquet
  size:    1.3 MB
  rows:    71,674
  symbols: 3,452

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-07-29 06:00:00	AAPL	Stock	9.3446	9.3636	9.3446	9.3636	17920.0
2010-07-29 06:30:00	AAPL	Stock	9.3518	9.3518	9.3393	9.3393	5600.0
2010-07-29 07:00:00	AAPL	Stock	9.3589	9.3589	9.3304	9.3321	120736.0
2010-07-29 07:30:00	AAPL	Stock	9.325	9.3471	9.325	9.325	443100.0
2010-07-29 08:00:00	AAPL	Stock	9.3296	9.3343	9.305	9.3179	590604.0
2010-07-29 08:30:00	AAPL	Stock	9.3207	9.3389	9.3107	9.325	2115568.0
2010-07-29 09:00:00	AAPL	Stock	9.3239	9.3279	9.3036	9.3093	2311652.0
2010-07-29 09:30:00	AAPL	Stock	9.3111	9.3804	9.2679	9.3511	98967764.0
2010-07-29 10:00:00	AAPL	Stock	9.3511	9.3539	9.3132	9.3236	45028032.0
2010-07-29 10:30:00	AAPL	Stock	9.3239	9.33	9.2871	9.2893	32434724.0
2010-07-29 11:00:00	AAPL	Stock	9.2907	9.2911	9.2171	9.2179	47840884.0
2010-07-29 11:30:00	AAPL	Stock	9.2168	9.2232	9.1868	9.2004	45929156.0
2010-07-29 12:00:00	AAPL	Stock	9.2018	9.2046	9.1571	9.1725	40602772.0
2010-07-29 12:30:00	AAPL	Stock	9.1725	9.1893	9.1464	9.1871	39399584.0
2010-07-29 13:00:00	AAPL	Stock	9.1864	9.2054	9.175	9.18	33185656.0
2010-07-29 13:30:00	AAPL	Stock	9.1786	9.2071	9.175	9.1857	34687996.0
2010-07-29 14:00:00	AAPL	Stock	9.1859	9.225	9.1679	9.2189	38839388.0
2010-07-29 14:30:00	AAPL	Stock	9.22	9.2911	9.22	9.2746	58350068.0
2010-07-29 15:00:00	AAPL	Stock	9.275	9.2996	9.2561	9.28	41425384.0
2010-07-29 15:30:00	AAPL	Stock	9.2786	9.28	9.2143	9.2182	61644492.0
2010-07-29 16:00:00	AAPL	Stock	9.2244	9.3191	9.21	9.21	17316936.0
2010-07-29 16:30:00	AAPL	Stock	9.2071	9.2774	9.2036	9.2054	642180.0
2010-07-29 17:00:00	AAPL	Stock	9.2182	9.2182	9.2036	9.2036	183288.0
2010-07-29 17:30:00	AAPL	Stock	9.2025	9.2029	9.2	9.2021	146888.0
2010-07-29 18:00:00	AAPL	Stock	9.2096	9.2182	9.2	9.2	109452.0
2010-07-29 18:30:00	AAPL	Stock	9.2121	9.2125	9.2039	9.2104	49056.0
2010-07-29 19:00:00	AAPL	Stock	9.2068	9.2104	9.2068	9.21	88116.0
2010-07-29 19:30:00	AAPL	Stock	9.2039	9.2089	9.2029	9.2036	76132.0
2010-07-29 04:00:00	MSFT	Stock	26.01	26.5	26.01	26.2	1100.0
2010-07-29 06:00:00	MSFT	Stock	26.15	26.15	26.15	26.15	2500.0
2010-07-29 06:30:00	MSFT	Stock	26.12	26.12	26.12	26.12	430.0
2010-07-29 07:00:00	MSFT	Stock	26.1	26.1	26.1	26.1	2000.0
2010-07-29 07:30:00	MSFT	Stock	26.08	26.08	26.08	26.08	1820.0
2010-07-29 08:00:00	MSFT	Stock	26.08	26.1	25.98	26.05	30651.0
2010-07-29 08:30:00	MSFT	Stock	26.0	26.08	26.0	26.08	18450.0
2010-07-29 09:00:00	MSFT	Stock	26.07	26.18	26.07	26.12	61100.0
2010-07-29 09:30:00	MSFT	Stock	26.13	26.19	25.98	26.0	4496317.0
2010-07-29 10:00:00	MSFT	Stock	26.0	26.11	25.96	26.0	3923140.0
2010-07-29 10:30:00	MSFT	Stock	26.0	26.13	25.96	26.008	2961217.0
2010-07-29 11:00:00	MSFT	Stock	26.005	26.01	25.76	25.78	4885345.0
2010-07-29 11:30:00	MSFT	Stock	25.77	25.8	25.64	25.76	6137114.0
2010-07-29 12:00:00	MSFT	Stock	25.76	25.765	25.6	25.69	3734415.0
2010-07-29 12:30:00	MSFT	Stock	25.68	25.78	25.67	25.77	3380654.0
2010-07-29 13:00:00	MSFT	Stock	25.76	26.07	25.75	26.07	5058093.0
2010-07-29 13:30:00	MSFT	Stock	26.06	26.26	26.06	26.201	5386914.0
2010-07-29 14:00:00	MSFT	Stock	26.2	26.3	26.14	26.28	4386540.0
2010-07-29 14:30:00	MSFT	Stock	26.29	26.41	26.25	26.36	6219577.0
2010-07-29 15:00:00	MSFT	Stock	26.36	26.38	26.25	26.25	4426758.0
2010-07-29 15:30:00	MSFT	Stock	26.25	26.27	26.03	26.04	8394150.0
2010-07-29 16:00:00	MSFT	Stock	26.03	26.06	26.0	26.02	5294714.0

> showing 50 of 71,674 rows — these rows as CSV

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