PREVIEW / etf_30min / 2012-12-10

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-12-10.parquet
  size:    280 KB
  rows:    9,719

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
2012-12-10 04:00:00	SPY	ETF	142.06	142.06	141.96	141.96	15348.0
2012-12-10 04:30:00	SPY	ETF	141.96	141.96	141.88	141.88	7350.0
2012-12-10 05:00:00	SPY	ETF	141.88	141.89	141.88	141.88	24000.0
2012-12-10 05:30:00	SPY	ETF	141.86	141.91	141.77	141.91	10844.0
2012-12-10 06:00:00	SPY	ETF	141.94	141.98	141.94	141.95	27390.0
2012-12-10 06:30:00	SPY	ETF	141.95	142.09	141.95	142.03	78249.0
2012-12-10 07:00:00	SPY	ETF	142.06	142.09	141.93	142.03	132600.0
2012-12-10 07:30:00	SPY	ETF	142.04	142.05	141.93	141.97	105987.0
2012-12-10 08:00:00	SPY	ETF	142.02	142.23	142.01	142.18	342047.0
2012-12-10 08:30:00	SPY	ETF	142.2	142.33	142.13	142.28	263230.0
2012-12-10 09:00:00	SPY	ETF	142.27	142.29	142.11	142.2	357641.0
2012-12-10 09:30:00	SPY	ETF	142.21	142.56	142.15	142.475	12877566.0
2012-12-10 10:00:00	SPY	ETF	142.47	142.62	142.35	142.4684	7650531.0
2012-12-10 10:30:00	SPY	ETF	142.46	142.8	142.45	142.795	5773047.0
2012-12-10 11:00:00	SPY	ETF	142.79	142.81	142.62	142.66	5856753.0
2012-12-10 11:30:00	SPY	ETF	142.66	142.75	142.56	142.615	3856994.0
2012-12-10 12:00:00	SPY	ETF	142.61	142.78	142.59	142.67	2781344.0
2012-12-10 12:30:00	SPY	ETF	142.67	142.72	142.56	142.65	2931112.0
2012-12-10 13:00:00	SPY	ETF	142.645	142.65	142.5	142.515	3568069.0
2012-12-10 13:30:00	SPY	ETF	142.515	142.59	142.47	142.48	3081799.0
2012-12-10 14:00:00	SPY	ETF	142.49	142.57	142.47	142.5	3949992.0
2012-12-10 14:30:00	SPY	ETF	142.4953	142.58	142.28	142.55	5890498.0
2012-12-10 15:00:00	SPY	ETF	142.55	142.62	142.47	142.61	6967468.0
2012-12-10 15:30:00	SPY	ETF	142.61	142.67	142.45	142.51	13156716.0
2012-12-10 16:00:00	SPY	ETF	142.5	142.75	142.3291	142.63	8649666.0
2012-12-10 16:30:00	SPY	ETF	142.64	142.7366	142.4312	142.48	4833438.0
2012-12-10 17:00:00	SPY	ETF	142.49	142.52	142.44	142.45	485467.0
2012-12-10 17:30:00	SPY	ETF	142.44	142.52	142.38	142.4	109594.0
2012-12-10 18:00:00	SPY	ETF	142.4	142.46	142.32	142.33	115880.0
2012-12-10 18:30:00	SPY	ETF	142.36	142.38	142.32	142.32	9320.0
2012-12-10 19:00:00	SPY	ETF	142.35	142.36	142.32	142.36	21830.0
2012-12-10 19:30:00	SPY	ETF	142.37	142.38	142.32	142.34	40840.0
2012-12-10 05:30:00	QQQ	ETF	64.7	64.7	64.7	64.7	1800.0
2012-12-10 06:00:00	QQQ	ETF	64.67	64.72	64.67	64.72	1380.0
2012-12-10 06:30:00	QQQ	ETF	64.73	64.73	64.73	64.73	152.0
2012-12-10 07:00:00	QQQ	ETF	64.74	64.75	64.69	64.7	2200.0
2012-12-10 07:30:00	QQQ	ETF	64.72	64.74	64.69	64.74	4000.0
2012-12-10 08:00:00	QQQ	ETF	64.68	64.842	64.68	64.77	1113730.0
2012-12-10 08:30:00	QQQ	ETF	64.76	64.82	64.74	64.8	26558.0
2012-12-10 09:00:00	QQQ	ETF	64.82	64.82	64.7	64.75	68764.0
2012-12-10 09:30:00	QQQ	ETF	64.75	65.23	64.75	65.16	4980429.0
2012-12-10 10:00:00	QQQ	ETF	65.16	65.26	65.03	65.14	2634741.0
2012-12-10 10:30:00	QQQ	ETF	65.1425	65.45	65.14	65.44	2085510.0
2012-12-10 11:00:00	QQQ	ETF	65.45	65.455	65.32	65.34	1830686.0
2012-12-10 11:30:00	QQQ	ETF	65.34	65.39	65.21	65.23	1049479.0
2012-12-10 12:00:00	QQQ	ETF	65.23	65.31	65.18	65.2	977118.0
2012-12-10 12:30:00	QQQ	ETF	65.2	65.25	65.08	65.115	890222.0
2012-12-10 13:00:00	QQQ	ETF	65.11	65.12	64.99	65.05	973048.0
2012-12-10 13:30:00	QQQ	ETF	65.05	65.13	65.005	65.08	668236.0
2012-12-10 14:00:00	QQQ	ETF	65.09	65.15	65.06	65.1001	591703.0

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

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