PREVIEW / etf_30min / 2013-07-10

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-07-10.parquet
  size:    322 KB
  rows:    10,912

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
2013-07-10 04:00:00	SPY	ETF	165.13	165.13	164.71	164.73	7726.0
2013-07-10 04:30:00	SPY	ETF	164.7	164.72	164.61	164.68	5450.0
2013-07-10 05:00:00	SPY	ETF	164.68	164.84	164.68	164.68	27200.0
2013-07-10 05:30:00	SPY	ETF	164.71	164.84	164.68	164.84	34200.0
2013-07-10 06:00:00	SPY	ETF	164.86	164.88	164.8	164.8	15550.0
2013-07-10 06:30:00	SPY	ETF	164.77	164.91	164.7	164.7	28100.0
2013-07-10 07:00:00	SPY	ETF	164.68	164.85	164.67	164.72	69242.0
2013-07-10 07:30:00	SPY	ETF	164.76	164.96	164.67	164.93	115536.0
2013-07-10 08:00:00	SPY	ETF	164.7	164.99	164.7	164.97	322991.0
2013-07-10 08:30:00	SPY	ETF	164.97	165.09	164.95	165.0	208120.0
2013-07-10 09:00:00	SPY	ETF	165.0	165.01	164.82	164.98	780082.0
2013-07-10 09:30:00	SPY	ETF	164.97	165.23	164.97	165.18	10750792.0
2013-07-10 10:00:00	SPY	ETF	165.19	165.28	164.85	164.94	8829303.0
2013-07-10 10:30:00	SPY	ETF	164.93	164.97	164.77	164.89	6927068.0
2013-07-10 11:00:00	SPY	ETF	164.9	164.95	164.7	164.73	4990985.0
2013-07-10 11:30:00	SPY	ETF	164.73	165.05	164.73	164.82	4645278.0
2013-07-10 12:00:00	SPY	ETF	164.83	164.94	164.75	164.81	2794871.0
2013-07-10 12:30:00	SPY	ETF	164.8	165.03	164.8	164.95	3626197.0
2013-07-10 13:00:00	SPY	ETF	164.94	164.961	164.83	164.889	2722431.0
2013-07-10 13:30:00	SPY	ETF	164.881	165.07	164.88	164.94	3219867.0
2013-07-10 14:00:00	SPY	ETF	164.93	165.75	164.83	165.23	26085936.0
2013-07-10 14:30:00	SPY	ETF	165.23	165.38	164.63	164.88	12321278.0
2013-07-10 15:00:00	SPY	ETF	164.88	165.27	164.68	165.09	9327644.0
2013-07-10 15:30:00	SPY	ETF	165.095	165.23	164.9114	165.16	11484161.0
2013-07-10 16:00:00	SPY	ETF	165.2	165.37	164.9174	165.37	6747717.0
2013-07-10 16:30:00	SPY	ETF	165.38	165.9	165.31	165.9	655905.0
2013-07-10 17:00:00	SPY	ETF	165.88	166.33	165.83	166.09	1707648.0
2013-07-10 17:30:00	SPY	ETF	166.09	166.24	166.01	166.24	195800.0
2013-07-10 18:00:00	SPY	ETF	166.23	166.57	166.2	166.48	544804.0
2013-07-10 18:30:00	SPY	ETF	166.49	166.79	166.48	166.72	209414.0
2013-07-10 19:00:00	SPY	ETF	166.69	166.69	166.52	166.64	154027.0
2013-07-10 19:30:00	SPY	ETF	166.62	166.69	166.57	166.69	222987.0
2013-07-10 04:00:00	QQQ	ETF	73.09	73.09	72.98	72.98	5100.0
2013-07-10 04:30:00	QQQ	ETF	72.95	72.95	72.89	72.92	6100.0
2013-07-10 05:00:00	QQQ	ETF	72.91	72.98	72.91	72.95	5500.0
2013-07-10 05:30:00	QQQ	ETF	72.92	72.98	72.92	72.98	3000.0
2013-07-10 06:00:00	QQQ	ETF	72.95	72.95	72.95	72.95	1000.0
2013-07-10 06:30:00	QQQ	ETF	72.92	72.92	72.89	72.89	2000.0
2013-07-10 07:00:00	QQQ	ETF	72.9	72.94	72.9	72.9	4328.0
2013-07-10 07:30:00	QQQ	ETF	72.89	72.99	72.89	72.99	3100.0
2013-07-10 08:00:00	QQQ	ETF	72.99	73.02	72.89	72.98	15233.0
2013-07-10 08:30:00	QQQ	ETF	73.01	73.04	73.01	73.01	7200.0
2013-07-10 09:00:00	QQQ	ETF	72.98	72.98	72.93	72.97	126576.0
2013-07-10 09:30:00	QQQ	ETF	72.98	73.33	72.98	73.3	2761920.0
2013-07-10 10:00:00	QQQ	ETF	73.3	73.35	73.14	73.24	1921190.0
2013-07-10 10:30:00	QQQ	ETF	73.23	73.26	73.16	73.23	1421916.0
2013-07-10 11:00:00	QQQ	ETF	73.22	73.25	73.12	73.18	882545.0
2013-07-10 11:30:00	QQQ	ETF	73.19	73.33	73.18	73.23	900518.0
2013-07-10 12:00:00	QQQ	ETF	73.225	73.29	73.2	73.23	435820.0
2013-07-10 12:30:00	QQQ	ETF	73.23	73.37	73.23	73.295	714656.0

> showing 50 of 10,912 rows — these rows as CSV

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