PREVIEW / stock_30min / 2010-11-16

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-11-16.parquet
  size:    1.4 MB
  rows:    78,778
  symbols: 3,517

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-11-16 05:00:00	AAPL	Stock	10.9775	10.9943	10.9775	10.9943	11200.0
2010-11-16 06:00:00	AAPL	Stock	10.9736	10.9746	10.9736	10.9746	21560.0
2010-11-16 06:30:00	AAPL	Stock	10.9643	10.9643	10.9582	10.9632	14000.0
2010-11-16 07:00:00	AAPL	Stock	10.9607	10.9607	10.9311	10.9311	124180.0
2010-11-16 07:30:00	AAPL	Stock	10.9314	10.9471	10.9036	10.9139	313236.0
2010-11-16 08:00:00	AAPL	Stock	10.9143	10.9489	10.8929	10.9464	1459752.0
2010-11-16 08:30:00	AAPL	Stock	10.945	10.9693	10.9414	10.95	1309560.0
2010-11-16 09:00:00	AAPL	Stock	10.9507	10.9507	10.9146	10.9232	2563204.0
2010-11-16 09:30:00	AAPL	Stock	10.9271	10.9857	10.8875	10.9132	68538736.0
2010-11-16 10:00:00	AAPL	Stock	10.9114	10.9182	10.8518	10.8786	55192256.0
2010-11-16 10:30:00	AAPL	Stock	10.8779	10.8814	10.81	10.8306	59835580.0
2010-11-16 11:00:00	AAPL	Stock	10.8307	10.8311	10.7175	10.7568	85794268.0
2010-11-16 11:30:00	AAPL	Stock	10.7564	10.7768	10.7232	10.7643	51961924.0
2010-11-16 12:00:00	AAPL	Stock	10.7636	10.8086	10.7629	10.7971	40909204.0
2010-11-16 12:30:00	AAPL	Stock	10.7971	10.7986	10.7539	10.7953	25785816.0
2010-11-16 13:00:00	AAPL	Stock	10.7936	10.8232	10.7757	10.8195	22908956.0
2010-11-16 13:30:00	AAPL	Stock	10.8186	10.8375	10.8086	10.8279	25280220.0
2010-11-16 14:00:00	AAPL	Stock	10.8286	10.8393	10.7804	10.7879	24800888.0
2010-11-16 14:30:00	AAPL	Stock	10.7886	10.805	10.7607	10.7768	28483644.0
2010-11-16 15:00:00	AAPL	Stock	10.7761	10.7839	10.69	10.7521	72300060.0
2010-11-16 15:30:00	AAPL	Stock	10.7511	10.7839	10.7325	10.7586	60421228.0
2010-11-16 16:00:00	AAPL	Stock	10.7643	10.9056	10.75	10.7536	18095728.0
2010-11-16 16:30:00	AAPL	Stock	10.7589	10.7621	10.7482	10.7536	398552.0
2010-11-16 17:00:00	AAPL	Stock	10.75	10.7668	10.75	10.7661	196280.0
2010-11-16 17:30:00	AAPL	Stock	10.7625	10.7668	10.7539	10.7607	1033172.0
2010-11-16 18:00:00	AAPL	Stock	10.7646	10.7711	10.7611	10.7625	408968.0
2010-11-16 18:30:00	AAPL	Stock	10.7625	10.7696	10.7579	10.7625	443352.0
2010-11-16 19:00:00	AAPL	Stock	10.7625	10.775	10.7618	10.7679	189028.0
2010-11-16 19:30:00	AAPL	Stock	10.7696	10.7782	10.7696	10.7782	125860.0
2010-11-16 04:30:00	MSFT	Stock	26.1	26.1	26.05	26.05	1050.0
2010-11-16 06:30:00	MSFT	Stock	26.05	26.05	26.05	26.05	100.0
2010-11-16 07:00:00	MSFT	Stock	26.01	26.05	25.97	26.02	9825.0
2010-11-16 07:30:00	MSFT	Stock	26.02	26.04	26.02	26.03	4600.0
2010-11-16 08:00:00	MSFT	Stock	26.03	26.05	26.01	26.03	52292.0
2010-11-16 08:30:00	MSFT	Stock	26.03	26.13	26.03	26.06	16874.0
2010-11-16 09:00:00	MSFT	Stock	26.05	26.07	25.98	26.03	112084.0
2010-11-16 09:30:00	MSFT	Stock	26.04	26.04	25.69	25.79	9266693.0
2010-11-16 10:00:00	MSFT	Stock	25.79	25.93	25.745	25.89	5258223.0
2010-11-16 10:30:00	MSFT	Stock	25.9	25.9	25.785	25.81	4920718.0
2010-11-16 11:00:00	MSFT	Stock	25.805	25.81	25.69	25.792	4926949.0
2010-11-16 11:30:00	MSFT	Stock	25.792	25.84	25.65	25.81	3793621.0
2010-11-16 12:00:00	MSFT	Stock	25.81	25.85	25.76	25.8	2745822.0
2010-11-16 12:30:00	MSFT	Stock	25.79	25.825	25.73	25.825	2944094.0
2010-11-16 13:00:00	MSFT	Stock	25.82	25.86	25.78	25.84	2026487.0
2010-11-16 13:30:00	MSFT	Stock	25.845	25.9	25.805	25.88	3446315.0
2010-11-16 14:00:00	MSFT	Stock	25.88	25.92	25.848	25.88	3536305.0
2010-11-16 14:30:00	MSFT	Stock	25.88	25.91	25.79	25.9	2600071.0
2010-11-16 15:00:00	MSFT	Stock	25.892	25.9	25.66	25.805	4917936.0
2010-11-16 15:30:00	MSFT	Stock	25.8	25.86	25.77	25.79	7592896.0
2010-11-16 16:00:00	MSFT	Stock	25.805	25.84	25.72	25.79	3100979.0

> showing 50 of 78,778 rows — these rows as CSV

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