PREVIEW / etf_30min / 2011-03-04

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-03-04.parquet
  size:    278 KB
  rows:    9,218

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
2011-03-04 04:00:00	SPY	ETF	133.57	133.57	133.55	133.55	800.0
2011-03-04 04:30:00	SPY	ETF	133.61	133.61	133.56	133.56	2500.0
2011-03-04 05:00:00	SPY	ETF	133.73	133.73	133.73	133.73	2000.0
2011-03-04 05:30:00	SPY	ETF	133.68	133.68	133.68	133.68	400.0
2011-03-04 06:00:00	SPY	ETF	133.69	133.69	133.58	133.58	42350.0
2011-03-04 06:30:00	SPY	ETF	133.58	133.58	133.41	133.41	106415.0
2011-03-04 07:00:00	SPY	ETF	133.43	133.62	133.41	133.6	196720.0
2011-03-04 07:30:00	SPY	ETF	133.62	133.7	133.53	133.57	340486.0
2011-03-04 08:00:00	SPY	ETF	133.54	133.7	133.49	133.7	855788.0
2011-03-04 08:30:00	SPY	ETF	133.7	133.9	133.12	133.27	5999930.0
2011-03-04 09:00:00	SPY	ETF	133.27	133.58	133.24	133.36	1467204.0
2011-03-04 09:30:00	SPY	ETF	133.37	133.48	133.09	133.25	20412775.0
2011-03-04 10:00:00	SPY	ETF	133.25	133.34	132.16	132.59	24614056.0
2011-03-04 10:30:00	SPY	ETF	132.595	133.63	132.53	132.82	15792718.0
2011-03-04 11:00:00	SPY	ETF	132.82	132.87	131.79	132.535	14269486.0
2011-03-04 11:30:00	SPY	ETF	132.53	132.85	132.27	132.32	20791895.0
2011-03-04 12:00:00	SPY	ETF	132.33	132.36	131.67	131.8	24863774.0
2011-03-04 12:30:00	SPY	ETF	131.81	131.94	131.61	131.815	13524280.0
2011-03-04 13:00:00	SPY	ETF	131.82	131.96	131.67	131.835	9846415.0
2011-03-04 13:30:00	SPY	ETF	131.84	133.4619	131.63	131.81	14247193.0
2011-03-04 14:00:00	SPY	ETF	131.81	131.87	131.6	131.82	9235070.0
2011-03-04 14:30:00	SPY	ETF	131.82	132.06	131.77	132.04	7713528.0
2011-03-04 15:00:00	SPY	ETF	132.04	132.23	131.67	131.74	13938320.0
2011-03-04 15:30:00	SPY	ETF	131.74	132.55	131.61	132.44	31168365.0
2011-03-04 16:00:00	SPY	ETF	132.45	133.4618	132.42	132.46	20057397.0
2011-03-04 16:30:00	SPY	ETF	132.47	133.4619	132.4	132.45	12262137.0
2011-03-04 17:00:00	SPY	ETF	132.43	133.4619	132.29	132.3	13380933.0
2011-03-04 17:30:00	SPY	ETF	132.29	132.31	132.25	132.25	139643.0
2011-03-04 18:00:00	SPY	ETF	132.3	132.48	132.25	132.37	186724.0
2011-03-04 18:30:00	SPY	ETF	132.36	132.42	132.34	132.35	119059.0
2011-03-04 19:00:00	SPY	ETF	132.35	132.37	132.35	132.35	26940.0
2011-03-04 19:30:00	SPY	ETF	132.35	132.4	132.34	132.39	52796.0
2011-03-04 04:00:00	QQQ	ETF	58.32	58.32	58.32	58.32	496.0
2011-03-04 04:30:00	QQQ	ETF	58.37	58.37	58.33	58.33	200.0
2011-03-04 05:00:00	QQQ	ETF	58.39	58.39	58.39	58.39	100.0
2011-03-04 06:00:00	QQQ	ETF	58.35	58.35	58.3	58.3	1413.0
2011-03-04 06:30:00	QQQ	ETF	58.27	58.27	58.22	58.24	7813.0
2011-03-04 07:00:00	QQQ	ETF	58.24	58.33	58.23	58.3	6322.0
2011-03-04 07:30:00	QQQ	ETF	58.32	58.37	58.3	58.32	24971.0
2011-03-04 08:00:00	QQQ	ETF	58.34	58.37	58.31	58.36	215772.0
2011-03-04 08:30:00	QQQ	ETF	58.36	58.43	58.14	58.21	1587677.0
2011-03-04 09:00:00	QQQ	ETF	58.2	58.29	58.15	58.26	574947.0
2011-03-04 09:30:00	QQQ	ETF	58.25	58.26	58.01	58.16	8383266.0
2011-03-04 10:00:00	QQQ	ETF	58.16	58.2	57.86	57.96	5564479.0
2011-03-04 10:30:00	QQQ	ETF	57.96	58.16	57.93	58.12	4029573.0
2011-03-04 11:00:00	QQQ	ETF	58.13	58.15	57.99	57.99	3174856.0
2011-03-04 11:30:00	QQQ	ETF	57.99	58.1319	57.91	57.94	2947627.0
2011-03-04 12:00:00	QQQ	ETF	57.94	57.9599	57.59	57.6795	5232152.0
2011-03-04 12:30:00	QQQ	ETF	57.67	57.79	57.6	57.7098	3341505.0
2011-03-04 13:00:00	QQQ	ETF	57.71	57.78	57.66	57.72	1633664.0

> showing 50 of 9,218 rows — these rows as CSV

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