PREVIEW / etf_30min / 2012-06-21

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-06-21.parquet
  size:    295 KB
  rows:    9,800

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-06-21 04:00:00	SPY	ETF	135.0	135.13	134.97	135.13	1800.0
2012-06-21 04:30:00	SPY	ETF	135.12	135.12	135.12	135.12	2500.0
2012-06-21 05:00:00	SPY	ETF	135.12	135.36	135.12	135.32	31034.0
2012-06-21 05:30:00	SPY	ETF	135.31	135.36	135.3	135.32	12620.0
2012-06-21 06:00:00	SPY	ETF	135.29	135.34	135.25	135.27	48110.0
2012-06-21 06:30:00	SPY	ETF	135.32	135.32	135.22	135.26	10200.0
2012-06-21 07:00:00	SPY	ETF	135.26	135.65	135.22	135.61	77555.0
2012-06-21 07:30:00	SPY	ETF	135.61	135.88	135.61	135.62	137862.0
2012-06-21 08:00:00	SPY	ETF	135.62	135.76	135.47	135.58	337665.0
2012-06-21 08:30:00	SPY	ETF	135.53	135.78	135.44	135.55	707526.0
2012-06-21 09:00:00	SPY	ETF	135.55	135.85	135.42	135.64	1615513.0
2012-06-21 09:30:00	SPY	ETF	135.64	135.78	135.26	135.31	13907305.0
2012-06-21 10:00:00	SPY	ETF	135.31	135.34	134.74	134.8525	18329153.0
2012-06-21 10:30:00	SPY	ETF	134.85	135.135	134.78	134.955	8161905.0
2012-06-21 11:00:00	SPY	ETF	134.95	134.965	134.22	134.29	14832996.0
2012-06-21 11:30:00	SPY	ETF	134.29	134.34	134.02	134.32	12572998.0
2012-06-21 12:00:00	SPY	ETF	134.32	134.37	133.43	133.48	14358083.0
2012-06-21 12:30:00	SPY	ETF	133.5	133.71	133.45	133.66	11162852.0
2012-06-21 13:00:00	SPY	ETF	133.65	133.77	133.38	133.38	11977437.0
2012-06-21 13:30:00	SPY	ETF	133.3899	133.52	133.14	133.26	10195075.0
2012-06-21 14:00:00	SPY	ETF	133.26	133.33	132.79	132.95	10899153.0
2012-06-21 14:30:00	SPY	ETF	132.95	133.15	132.85	133.049	9890624.0
2012-06-21 15:00:00	SPY	ETF	133.04	133.09	132.55	132.81	15044671.0
2012-06-21 15:30:00	SPY	ETF	132.8105	132.97	132.33	132.46	31437197.0
2012-06-21 16:00:00	SPY	ETF	132.46	135.4876	132.22	132.46	12919460.0
2012-06-21 16:30:00	SPY	ETF	132.46	132.49	132.4	132.45	870770.0
2012-06-21 17:00:00	SPY	ETF	132.44	132.74	132.39	132.69	604746.0
2012-06-21 17:30:00	SPY	ETF	132.7	132.8	132.66	132.76	197533.0
2012-06-21 18:00:00	SPY	ETF	132.76	132.8	132.72	132.76	87603.0
2012-06-21 18:30:00	SPY	ETF	132.73	132.75	132.68	132.7	25080.0
2012-06-21 19:00:00	SPY	ETF	132.7	132.78	132.7	132.7	22928.0
2012-06-21 19:30:00	SPY	ETF	132.71	132.71	132.63	132.65	44534.0
2012-06-21 04:00:00	QQQ	ETF	64.19	64.19	64.19	64.19	100.0
2012-06-21 07:00:00	QQQ	ETF	64.12	64.28	64.12	64.28	10340.0
2012-06-21 07:30:00	QQQ	ETF	64.29	64.37	64.29	64.37	6500.0
2012-06-21 08:00:00	QQQ	ETF	64.27	64.32	64.17	64.25	32375.0
2012-06-21 08:30:00	QQQ	ETF	64.23	64.34	64.16	64.2	68320.0
2012-06-21 09:00:00	QQQ	ETF	64.21	64.29	64.17	64.22	156533.0
2012-06-21 09:30:00	QQQ	ETF	64.21	64.31	64.025	64.05	3059687.0
2012-06-21 10:00:00	QQQ	ETF	64.05	64.06	63.79	63.9	3839813.0
2012-06-21 10:30:00	QQQ	ETF	63.89	64.0682	63.85	63.99	2121047.0
2012-06-21 11:00:00	QQQ	ETF	64.0	64.0	63.5401	63.59	3165077.0
2012-06-21 11:30:00	QQQ	ETF	63.59	63.63	63.46	63.6	2316794.0
2012-06-21 12:00:00	QQQ	ETF	63.6005	63.63	63.22	63.24	2307028.0
2012-06-21 12:30:00	QQQ	ETF	63.24	63.31	63.2	63.26	1612291.0
2012-06-21 13:00:00	QQQ	ETF	63.26	63.34	63.17	63.1873	1370273.0
2012-06-21 13:30:00	QQQ	ETF	63.1895	63.25	63.06	63.16	1986661.0
2012-06-21 14:00:00	QQQ	ETF	63.1599	63.16	62.92	63.0	2819708.0
2012-06-21 14:30:00	QQQ	ETF	63.0	63.11	62.97	63.04	1720659.0
2012-06-21 15:00:00	QQQ	ETF	63.04	63.06	62.73	62.835	3607337.0

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

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