PREVIEW / etf_30min / 2011-06-06

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-06-06.parquet
  size:    286 KB
  rows:    9,468

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-06-06 04:00:00	SPY	ETF	130.05	130.05	129.97	130.0	1800.0
2011-06-06 05:00:00	SPY	ETF	130.2	130.24	130.11	130.11	600.0
2011-06-06 05:30:00	SPY	ETF	130.12	130.12	130.01	130.1	21700.0
2011-06-06 06:00:00	SPY	ETF	130.01	130.07	129.99	129.99	900.0
2011-06-06 06:30:00	SPY	ETF	129.96	130.05	129.88	129.88	14350.0
2011-06-06 07:00:00	SPY	ETF	129.92	129.98	129.82	129.93	137665.0
2011-06-06 07:30:00	SPY	ETF	129.93	129.95	129.75	129.79	169355.0
2011-06-06 08:00:00	SPY	ETF	129.75	130.12	129.75	130.1	1181246.0
2011-06-06 08:30:00	SPY	ETF	130.08	130.27	129.855	130.16	937306.0
2011-06-06 09:00:00	SPY	ETF	130.16	130.42	130.05	130.08	5771890.0
2011-06-06 09:30:00	SPY	ETF	130.09	130.36	129.855	129.99	19911239.0
2011-06-06 10:00:00	SPY	ETF	129.99	130.02	129.53	129.87	18020270.0
2011-06-06 10:30:00	SPY	ETF	129.87	129.93	129.55	129.6671	11322760.0
2011-06-06 11:00:00	SPY	ETF	129.67	130.08	129.62	130.045	9916257.0
2011-06-06 11:30:00	SPY	ETF	130.05	130.16	129.93	130.05	7016018.0
2011-06-06 12:00:00	SPY	ETF	130.06	130.12	129.94	130.07	4975800.0
2011-06-06 12:30:00	SPY	ETF	130.06	130.06	129.8	129.9	4467785.0
2011-06-06 13:00:00	SPY	ETF	129.8933	130.05	129.77	129.82	5253451.0
2011-06-06 13:30:00	SPY	ETF	129.83	129.86	129.39	129.519	9614176.0
2011-06-06 14:00:00	SPY	ETF	129.52	129.72	129.47	129.565	6072839.0
2011-06-06 14:30:00	SPY	ETF	129.56	129.63	129.18	129.28	11023745.0
2011-06-06 15:00:00	SPY	ETF	129.2801	129.6	128.87	129.05	18953508.0
2011-06-06 15:30:00	SPY	ETF	129.04	129.4	129.01	129.05	29631541.0
2011-06-06 16:00:00	SPY	ETF	129.04	129.6	128.975	129.03	13953309.0
2011-06-06 16:30:00	SPY	ETF	129.04	129.06	128.94	129.02	448906.0
2011-06-06 17:00:00	SPY	ETF	129.0	129.01	128.92	128.99	146053.0
2011-06-06 17:30:00	SPY	ETF	128.99	129.0	128.93	128.93	264984.0
2011-06-06 18:00:00	SPY	ETF	128.96	129.11	128.94	129.04	606962.0
2011-06-06 18:30:00	SPY	ETF	129.05	129.07	129.0	129.01	20579.0
2011-06-06 19:00:00	SPY	ETF	129.03	129.08	129.03	129.08	71820.0
2011-06-06 19:30:00	SPY	ETF	129.08	129.08	129.03	129.04	29156.0
2011-06-06 05:30:00	QQQ	ETF	56.26	56.26	56.23	56.23	300.0
2011-06-06 06:30:00	QQQ	ETF	56.13	56.14	56.0	56.14	700.0
2011-06-06 07:00:00	QQQ	ETF	56.14	56.15	56.1	56.12	27400.0
2011-06-06 07:30:00	QQQ	ETF	56.13	56.15	56.06	56.06	9855.0
2011-06-06 08:00:00	QQQ	ETF	56.05	56.22	56.05	56.22	168388.0
2011-06-06 08:30:00	QQQ	ETF	56.21	56.31	56.2	56.27	246233.0
2011-06-06 09:00:00	QQQ	ETF	56.26	56.33	56.24	56.24	291309.0
2011-06-06 09:30:00	QQQ	ETF	56.24	56.47	56.22	56.46	4161094.0
2011-06-06 10:00:00	QQQ	ETF	56.46	56.47	56.24	56.411	4396342.0
2011-06-06 10:30:00	QQQ	ETF	56.4187	56.45	56.21	56.27	3689096.0
2011-06-06 11:00:00	QQQ	ETF	56.26	56.5	56.25	56.47	2999936.0
2011-06-06 11:30:00	QQQ	ETF	56.47	56.53	56.38	56.41	1731179.0
2011-06-06 12:00:00	QQQ	ETF	56.41	56.43	56.34	56.375	805857.0
2011-06-06 12:30:00	QQQ	ETF	56.37	56.37	56.27	56.33	1353032.0
2011-06-06 13:00:00	QQQ	ETF	56.33	56.47	56.28	56.34	2171198.0
2011-06-06 13:30:00	QQQ	ETF	56.34	56.37	56.08	56.13	3966783.0
2011-06-06 14:00:00	QQQ	ETF	56.13	56.27	56.12	56.19	1079349.0
2011-06-06 14:30:00	QQQ	ETF	56.185	56.21	55.98	56.04	2828854.0
2011-06-06 15:00:00	QQQ	ETF	56.04	56.1	55.86	55.921	3135085.0

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

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