PREVIEW / etf_30min / 2011-12-27

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-12-27.parquet
  size:    268 KB
  rows:    9,192

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-12-27 04:00:00	SPY	ETF	126.48	126.48	126.48	126.48	100.0
2011-12-27 05:30:00	SPY	ETF	126.5	126.5	126.5	126.5	100.0
2011-12-27 06:30:00	SPY	ETF	126.46	126.46	126.39	126.43	22000.0
2011-12-27 07:00:00	SPY	ETF	126.38	126.38	126.17	126.22	66679.0
2011-12-27 07:30:00	SPY	ETF	126.22	126.27	126.15	126.26	73840.0
2011-12-27 08:00:00	SPY	ETF	126.24	126.42	126.12	126.21	593073.0
2011-12-27 08:30:00	SPY	ETF	126.2	126.28	126.09	126.17	266256.0
2011-12-27 09:00:00	SPY	ETF	126.18	126.39	126.04	126.16	660338.0
2011-12-27 09:30:00	SPY	ETF	126.17	126.82	126.06	126.72	12640316.0
2011-12-27 10:00:00	SPY	ETF	126.72	126.82	126.61	126.77	10075037.0
2011-12-27 10:30:00	SPY	ETF	126.78	126.78	126.34	126.399	5801959.0
2011-12-27 11:00:00	SPY	ETF	126.4	126.5709	126.36	126.5527	2846929.0
2011-12-27 11:30:00	SPY	ETF	126.56	126.57	126.44	126.54	4002099.0
2011-12-27 12:00:00	SPY	ETF	126.54	126.67	126.54	126.635	3140143.0
2011-12-27 12:30:00	SPY	ETF	126.63	126.67	126.56	126.585	4760441.0
2011-12-27 13:00:00	SPY	ETF	126.59	126.6	126.5	126.55	2149121.0
2011-12-27 13:30:00	SPY	ETF	126.55	126.75	126.53	126.72	2873078.0
2011-12-27 14:00:00	SPY	ETF	126.72	126.76	126.57	126.61	2987745.0
2011-12-27 14:30:00	SPY	ETF	126.62	126.72	126.51	126.7	3878953.0
2011-12-27 15:00:00	SPY	ETF	126.7	126.75	126.58	126.66	4749540.0
2011-12-27 15:30:00	SPY	ETF	126.65	126.67	126.41	126.46	10017868.0
2011-12-27 16:00:00	SPY	ETF	126.46	126.5867	126.39	126.4	8044614.0
2011-12-27 16:30:00	SPY	ETF	126.4	126.42	126.35	126.39	327431.0
2011-12-27 17:00:00	SPY	ETF	126.38	126.39	126.35	126.35	624596.0
2011-12-27 17:30:00	SPY	ETF	126.49	126.49	126.34	126.36	18872.0
2011-12-27 18:00:00	SPY	ETF	126.36	126.49	126.28	126.28	292512.0
2011-12-27 18:30:00	SPY	ETF	126.28	126.29	126.22	126.26	58350.0
2011-12-27 19:00:00	SPY	ETF	126.26	126.34	126.19	126.3	82369.0
2011-12-27 19:30:00	SPY	ETF	126.32	126.33	126.25	126.28	147577.0
2011-12-27 06:00:00	QQQ	ETF	56.06	56.06	56.06	56.06	700.0
2011-12-27 06:30:00	QQQ	ETF	56.05	56.05	56.05	56.05	100.0
2011-12-27 07:00:00	QQQ	ETF	56.04	56.04	55.92	55.92	2700.0
2011-12-27 07:30:00	QQQ	ETF	55.94	55.96	55.94	55.96	7920.0
2011-12-27 08:00:00	QQQ	ETF	55.94	56.13	55.94	56.01	51729.0
2011-12-27 08:30:00	QQQ	ETF	56.01	56.05	55.97	55.99	29999.0
2011-12-27 09:00:00	QQQ	ETF	55.98	56.01	55.93	56.01	56993.0
2011-12-27 09:30:00	QQQ	ETF	56.01	56.3	55.93	56.24	4153977.0
2011-12-27 10:00:00	QQQ	ETF	56.24	56.34	56.21	56.27	2402233.0
2011-12-27 10:30:00	QQQ	ETF	56.275	56.3	56.095	56.12	2155558.0
2011-12-27 11:00:00	QQQ	ETF	56.12	56.21	56.11	56.2	760094.0
2011-12-27 11:30:00	QQQ	ETF	56.21	56.24	56.172	56.23	632934.0
2011-12-27 12:00:00	QQQ	ETF	56.225	56.31	56.225	56.3	864911.0
2011-12-27 12:30:00	QQQ	ETF	56.3	56.32	56.275	56.29	513078.0
2011-12-27 13:00:00	QQQ	ETF	56.29	56.3	56.26	56.29	351413.0
2011-12-27 13:30:00	QQQ	ETF	56.29	56.4	56.29	56.385	1246641.0
2011-12-27 14:00:00	QQQ	ETF	56.385	56.42	56.34	56.37	969253.0
2011-12-27 14:30:00	QQQ	ETF	56.37	56.4	56.31	56.38	884959.0
2011-12-27 15:00:00	QQQ	ETF	56.38	56.39	56.33	56.365	719989.0
2011-12-27 15:30:00	QQQ	ETF	56.36	56.37	56.19	56.22	3417483.0
2011-12-27 16:00:00	QQQ	ETF	56.22	56.265	56.07	56.07	1445904.0

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

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