PREVIEW / etf_30min / 2014-12-12

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-12-12.parquet
  size:    377 KB
  rows:    12,804

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
2014-12-12 04:00:00	SPY	ETF	202.78	202.78	202.24	202.6	20386.0
2014-12-12 04:30:00	SPY	ETF	202.6	202.75	202.4	202.4	8520.0
2014-12-12 05:00:00	SPY	ETF	202.6	202.64	202.27	202.55	20955.0
2014-12-12 05:30:00	SPY	ETF	202.58	202.63	202.3	202.3	56906.0
2014-12-12 06:00:00	SPY	ETF	202.3	202.5	202.27	202.4	85750.0
2014-12-12 06:30:00	SPY	ETF	202.39	202.65	202.35	202.61	118099.0
2014-12-12 07:00:00	SPY	ETF	202.59	202.97	202.59	202.94	233634.0
2014-12-12 07:30:00	SPY	ETF	202.98	202.99	202.71	202.71	270733.0
2014-12-12 08:00:00	SPY	ETF	202.71	203.0	202.34	202.46	1179123.0
2014-12-12 08:30:00	SPY	ETF	202.49	202.98	202.43	202.59	1261946.0
2014-12-12 09:00:00	SPY	ETF	202.61	202.81	202.56	202.62	1573030.0
2014-12-12 09:30:00	SPY	ETF	202.64	203.819	202.44	203.73	21205871.0
2014-12-12 10:00:00	SPY	ETF	203.74	203.8	202.78	203.075	15222510.0
2014-12-12 10:30:00	SPY	ETF	203.08	203.45	202.17	202.26	14505312.0
2014-12-12 11:00:00	SPY	ETF	202.27	202.57	201.87	201.92	12508695.0
2014-12-12 11:30:00	SPY	ETF	201.93	202.55	201.78	201.86	13766380.0
2014-12-12 12:00:00	SPY	ETF	201.86	202.68	201.85	202.65	9375305.0
2014-12-12 12:30:00	SPY	ETF	202.65	202.74	202.34	202.44	6698275.0
2014-12-12 13:00:00	SPY	ETF	202.44	203.2	202.16	202.98	11265020.0
2014-12-12 13:30:00	SPY	ETF	202.98	203.15	202.6	203.03	5476590.0
2014-12-12 14:00:00	SPY	ETF	203.025	203.05	202.43	202.44	7959860.0
2014-12-12 14:30:00	SPY	ETF	202.445	202.58	202.17	202.565	7127038.0
2014-12-12 15:00:00	SPY	ETF	202.56	202.69	202.12	202.23	9464934.0
2014-12-12 15:30:00	SPY	ETF	202.24	202.24	200.85	200.87	34027815.0
2014-12-12 16:00:00	SPY	ETF	200.86	204.136	200.31	200.45	13580276.0
2014-12-12 16:30:00	SPY	ETF	200.45	200.62	200.38	200.49	4466421.0
2014-12-12 17:00:00	SPY	ETF	200.48	200.61	200.46	200.47	552887.0
2014-12-12 17:30:00	SPY	ETF	200.49	200.58	200.41	200.55	150811.0
2014-12-12 18:00:00	SPY	ETF	200.56	200.89	200.52	200.59	102951.0
2014-12-12 18:30:00	SPY	ETF	200.59	200.69	200.57	200.63	66881.0
2014-12-12 19:00:00	SPY	ETF	200.62	200.65	200.55	200.59	14266.0
2014-12-12 19:30:00	SPY	ETF	200.5901	200.63	200.55	200.56	49431.0
2014-12-12 04:00:00	QQQ	ETF	103.03	103.03	102.58	102.7	7676.0
2014-12-12 04:30:00	QQQ	ETF	102.8	102.8	102.75	102.75	6550.0
2014-12-12 05:00:00	QQQ	ETF	102.76	102.76	102.6	102.6	6510.0
2014-12-12 05:30:00	QQQ	ETF	102.85	102.86	102.78	102.78	23510.0
2014-12-12 06:00:00	QQQ	ETF	102.69	102.81	102.69	102.76	5400.0
2014-12-12 06:30:00	QQQ	ETF	102.76	102.88	102.76	102.86	5700.0
2014-12-12 07:00:00	QQQ	ETF	102.84	103.06	102.84	103.06	5099.0
2014-12-12 07:30:00	QQQ	ETF	103.08	103.1	102.95	102.97	22860.0
2014-12-12 08:00:00	QQQ	ETF	102.97	103.19	102.6457	102.6457	476490.0
2014-12-12 08:30:00	QQQ	ETF	102.8	103.1	102.8	102.95	193788.0
2014-12-12 09:00:00	QQQ	ETF	102.94	103.8	102.79	102.8	248709.0
2014-12-12 09:30:00	QQQ	ETF	102.8	103.99	102.715	103.93	9228955.0
2014-12-12 10:00:00	QQQ	ETF	103.95	103.99	103.37	103.7	4583212.0
2014-12-12 10:30:00	QQQ	ETF	103.705	103.82	103.08	103.13	2771775.0
2014-12-12 11:00:00	QQQ	ETF	103.14	103.5	102.951	103.1	3150839.0
2014-12-12 11:30:00	QQQ	ETF	103.11	103.635	103.11	103.25	2770430.0
2014-12-12 12:00:00	QQQ	ETF	103.25	103.53	103.16	103.5	2188997.0
2014-12-12 12:30:00	QQQ	ETF	103.5	103.58	103.29	103.35	1527472.0

> showing 50 of 12,804 rows — these rows as CSV

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