PREVIEW / etf_30min / 2013-10-31

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-10-31.parquet
  size:    330 KB
  rows:    11,109

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-10-31 04:00:00	SPY	ETF	175.88	176.11	175.88	176.0	14100.0
2013-10-31 04:30:00	SPY	ETF	175.98	176.05	175.96	175.98	3600.0
2013-10-31 05:00:00	SPY	ETF	175.96	175.98	175.9	175.96	4600.0
2013-10-31 05:30:00	SPY	ETF	175.97	176.13	175.97	176.13	3000.0
2013-10-31 06:00:00	SPY	ETF	176.08	176.16	176.06	176.08	1800.0
2013-10-31 06:30:00	SPY	ETF	176.06	176.14	176.06	176.12	3050.0
2013-10-31 07:00:00	SPY	ETF	176.07	176.21	176.01	176.21	84369.0
2013-10-31 07:30:00	SPY	ETF	176.21	176.36	176.16	176.24	128350.0
2013-10-31 08:00:00	SPY	ETF	176.26	176.45	176.22	176.43	506526.0
2013-10-31 08:30:00	SPY	ETF	176.41	176.41	176.21	176.24	391764.0
2013-10-31 09:00:00	SPY	ETF	176.25	176.29	176.11	176.15	1010902.0
2013-10-31 09:30:00	SPY	ETF	176.15	176.68	175.835	175.94	15346688.0
2013-10-31 10:00:00	SPY	ETF	175.94	175.99	175.61	175.83	9674875.0
2013-10-31 10:30:00	SPY	ETF	175.83	176.07	175.53	175.95	10792853.0
2013-10-31 11:00:00	SPY	ETF	175.94	176.35	175.88	176.28	8104010.0
2013-10-31 11:30:00	SPY	ETF	176.29	176.47	176.18	176.22	6359114.0
2013-10-31 12:00:00	SPY	ETF	176.22	176.395	176.14	176.33	7992246.0
2013-10-31 12:30:00	SPY	ETF	176.31	176.58	176.3	176.35	3551597.0
2013-10-31 13:00:00	SPY	ETF	176.35	176.51	176.32	176.48	1956281.0
2013-10-31 13:30:00	SPY	ETF	176.49	176.55	176.38	176.46	2495022.0
2013-10-31 14:00:00	SPY	ETF	176.47	176.88	176.37	176.8	6300660.0
2013-10-31 14:30:00	SPY	ETF	176.8	176.89	176.48	176.485	8196216.0
2013-10-31 15:00:00	SPY	ETF	176.485	176.49	176.16	176.17	9213107.0
2013-10-31 15:30:00	SPY	ETF	176.17	176.35	175.69	175.72	24183540.0
2013-10-31 16:00:00	SPY	ETF	175.72	176.3282	175.6536	175.94	10973335.0
2013-10-31 16:30:00	SPY	ETF	175.95	176.3282	175.7827	176.05	3190897.0
2013-10-31 17:00:00	SPY	ETF	176.045	176.06	175.959	176.03	145591.0
2013-10-31 17:30:00	SPY	ETF	176.03	176.03	176.01	176.02	14646.0
2013-10-31 18:00:00	SPY	ETF	176.02	176.02	175.79	175.86	372403.0
2013-10-31 18:30:00	SPY	ETF	175.86	175.97	175.84	175.96	10780.0
2013-10-31 19:00:00	SPY	ETF	175.96	175.96	175.81	175.84	29170.0
2013-10-31 19:30:00	SPY	ETF	175.84	175.92	175.84	175.91	15970.0
2013-10-31 04:00:00	QQQ	ETF	82.8	82.92	82.8	82.86	29300.0
2013-10-31 04:30:00	QQQ	ETF	82.85	82.89	82.82	82.85	16500.0
2013-10-31 05:00:00	QQQ	ETF	82.84	82.84	82.81	82.84	6100.0
2013-10-31 05:30:00	QQQ	ETF	82.85	82.91	82.85	82.89	6200.0
2013-10-31 06:00:00	QQQ	ETF	82.88	82.93	82.86	82.86	10300.0
2013-10-31 06:30:00	QQQ	ETF	82.87	82.89	82.87	82.89	1700.0
2013-10-31 07:00:00	QQQ	ETF	82.88	82.92	82.83	82.92	14350.0
2013-10-31 07:30:00	QQQ	ETF	82.92	82.98	82.9	82.94	45895.0
2013-10-31 08:00:00	QQQ	ETF	82.94	83.02	82.91	83.02	83530.0
2013-10-31 08:30:00	QQQ	ETF	83.02	83.02	82.85	82.85	160021.0
2013-10-31 09:00:00	QQQ	ETF	82.85	82.86	82.72	82.76	203994.0
2013-10-31 09:30:00	QQQ	ETF	82.77	83.09	82.56	82.59	5127069.0
2013-10-31 10:00:00	QQQ	ETF	82.59	82.75	82.48	82.65	3119917.0
2013-10-31 10:30:00	QQQ	ETF	82.649	82.96	82.53	82.91	3261827.0
2013-10-31 11:00:00	QQQ	ETF	82.92	83.13	82.915	83.09	1493201.0
2013-10-31 11:30:00	QQQ	ETF	83.09	83.2	83.08	83.1	1212919.0
2013-10-31 12:00:00	QQQ	ETF	83.095	83.18	83.02	83.15	873170.0
2013-10-31 12:30:00	QQQ	ETF	83.15	83.27	83.11	83.11	911099.0

> showing 50 of 11,109 rows — these rows as CSV

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