PREVIEW / etf_30min / 2011-03-10

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-03-10.parquet
  size:    293 KB
  rows:    9,728

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-10 04:00:00	SPY	ETF	131.0	131.25	131.0	131.24	2971.0
2011-03-10 04:30:00	SPY	ETF	131.32	131.39	131.29	131.29	5800.0
2011-03-10 05:00:00	SPY	ETF	131.37	131.37	131.37	131.37	100.0
2011-03-10 05:30:00	SPY	ETF	131.24	131.28	131.16	131.25	29622.0
2011-03-10 06:00:00	SPY	ETF	131.33	131.33	131.27	131.29	11100.0
2011-03-10 06:30:00	SPY	ETF	131.24	131.39	131.19	131.39	55700.0
2011-03-10 07:00:00	SPY	ETF	131.36	131.46	131.29	131.36	281118.0
2011-03-10 07:30:00	SPY	ETF	131.37	131.66	131.25	131.47	2141852.0
2011-03-10 08:00:00	SPY	ETF	131.44	131.75	131.29	131.5	2896170.0
2011-03-10 08:30:00	SPY	ETF	131.51	131.51	131.12	131.12	4544827.0
2011-03-10 09:00:00	SPY	ETF	131.12	131.21	130.98	131.01	4085437.0
2011-03-10 09:30:00	SPY	ETF	131.0	131.04	130.11	130.39	40933693.0
2011-03-10 10:00:00	SPY	ETF	130.39	130.44	129.9	130.21	24175873.0
2011-03-10 10:30:00	SPY	ETF	130.2	131.18	129.96	130.471	20729828.0
2011-03-10 11:00:00	SPY	ETF	130.47	130.62	130.29	130.5	13606703.0
2011-03-10 11:30:00	SPY	ETF	130.5	130.86	130.42	130.81	14696895.0
2011-03-10 12:00:00	SPY	ETF	130.8	130.86	130.38	130.48	11465977.0
2011-03-10 12:30:00	SPY	ETF	130.48	130.83	130.37	130.83	11269680.0
2011-03-10 13:00:00	SPY	ETF	130.83	130.97	130.36	130.4	14975883.0
2011-03-10 13:30:00	SPY	ETF	130.395	130.42	129.81	130.16	32033963.0
2011-03-10 14:00:00	SPY	ETF	130.16	130.45	130.0645	130.2	15167038.0
2011-03-10 14:30:00	SPY	ETF	130.2	130.64	130.18	130.38	9676621.0
2011-03-10 15:00:00	SPY	ETF	130.39	130.46	129.88	129.95	13141921.0
2011-03-10 15:30:00	SPY	ETF	129.95	130.38	129.83	129.92	26624233.0
2011-03-10 16:00:00	SPY	ETF	129.93	130.4	129.73	129.8	15365298.0
2011-03-10 16:30:00	SPY	ETF	129.82	132.4162	129.72	129.86	10263691.0
2011-03-10 17:00:00	SPY	ETF	129.89	130.04	129.77	129.79	10169889.0
2011-03-10 17:30:00	SPY	ETF	129.8	129.84	129.72	129.77	598917.0
2011-03-10 18:00:00	SPY	ETF	129.77	130.02	129.77	129.98	279156.0
2011-03-10 18:30:00	SPY	ETF	129.98	130.24	129.91	130.12	181761.0
2011-03-10 19:00:00	SPY	ETF	130.18	130.28	130.16	130.27	80509.0
2011-03-10 19:30:00	SPY	ETF	130.26	130.27	130.12	130.19	33856.0
2011-03-10 04:00:00	QQQ	ETF	56.7	56.7	56.36	56.36	1500.0
2011-03-10 04:30:00	QQQ	ETF	56.41	56.41	56.41	56.41	200.0
2011-03-10 05:00:00	QQQ	ETF	56.47	56.47	56.4	56.4	2300.0
2011-03-10 05:30:00	QQQ	ETF	56.39	56.45	56.39	56.45	1600.0
2011-03-10 06:00:00	QQQ	ETF	56.46	56.47	56.44	56.44	5800.0
2011-03-10 06:30:00	QQQ	ETF	56.41	56.45	56.37	56.45	4224.0
2011-03-10 07:00:00	QQQ	ETF	56.44	56.5	56.4	56.42	210825.0
2011-03-10 07:30:00	QQQ	ETF	56.43	56.59	56.4	56.54	194137.0
2011-03-10 08:00:00	QQQ	ETF	56.52	56.65	56.5	56.57	331364.0
2011-03-10 08:30:00	QQQ	ETF	56.55	56.56	56.38	56.4	2158339.0
2011-03-10 09:00:00	QQQ	ETF	56.39	56.44	56.3	56.39	1125820.0
2011-03-10 09:30:00	QQQ	ETF	56.39	56.42	56.0	56.1795	13597468.0
2011-03-10 10:00:00	QQQ	ETF	56.17	56.2	55.91	56.0901	8568454.0
2011-03-10 10:30:00	QQQ	ETF	56.09	56.235	55.94	56.2	5406836.0
2011-03-10 11:00:00	QQQ	ETF	56.21	56.28	56.11	56.2299	4246119.0
2011-03-10 11:30:00	QQQ	ETF	56.22	56.34	56.19	56.32	2603776.0
2011-03-10 12:00:00	QQQ	ETF	56.32	56.35	56.16	56.2	4347046.0
2011-03-10 12:30:00	QQQ	ETF	56.2062	56.47	56.15	56.46	5359775.0

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

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