PREVIEW / etf_30min / 2013-03-11

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-03-11.parquet
  size:    301 KB
  rows:    10,286

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-03-11 04:00:00	SPY	ETF	155.35	155.35	155.15	155.15	2200.0
2013-03-11 04:30:00	SPY	ETF	155.12	155.19	155.11	155.19	1202.0
2013-03-11 05:00:00	SPY	ETF	155.23	155.23	155.19	155.19	18000.0
2013-03-11 05:30:00	SPY	ETF	155.11	155.14	155.11	155.14	10100.0
2013-03-11 06:00:00	SPY	ETF	155.16	155.19	155.12	155.12	9600.0
2013-03-11 06:30:00	SPY	ETF	155.13	155.18	155.12	155.17	7690.0
2013-03-11 07:00:00	SPY	ETF	155.17	155.17	155.095	155.1	75230.0
2013-03-11 07:30:00	SPY	ETF	155.09	155.13	154.99	155.13	693260.0
2013-03-11 08:00:00	SPY	ETF	154.99	155.25	154.99	155.23	855541.0
2013-03-11 08:30:00	SPY	ETF	155.23	155.3	155.14	155.24	1643725.0
2013-03-11 09:00:00	SPY	ETF	155.25	155.36	155.24	155.33	429103.0
2013-03-11 09:30:00	SPY	ETF	155.325	155.42	155.13	155.35	11146188.0
2013-03-11 10:00:00	SPY	ETF	155.34	155.42	155.2	155.219	4662284.0
2013-03-11 10:30:00	SPY	ETF	155.219	155.43	155.2	155.3685	3649648.0
2013-03-11 11:00:00	SPY	ETF	155.36	155.53	155.32	155.475	4314543.0
2013-03-11 11:30:00	SPY	ETF	155.48	155.6	155.43	155.58	3493404.0
2013-03-11 12:00:00	SPY	ETF	155.59	155.745	155.58	155.681	4147488.0
2013-03-11 12:30:00	SPY	ETF	155.685	155.79	155.61	155.79	3043922.0
2013-03-11 13:00:00	SPY	ETF	155.785	155.9	155.78	155.86	4502124.0
2013-03-11 13:30:00	SPY	ETF	155.865	155.92	155.81	155.845	2807941.0
2013-03-11 14:00:00	SPY	ETF	155.845	155.95	155.81	155.875	3621916.0
2013-03-11 14:30:00	SPY	ETF	155.875	156.03	155.77	155.96	4149393.0
2013-03-11 15:00:00	SPY	ETF	155.96	155.96	155.81	155.8201	4882712.0
2013-03-11 15:30:00	SPY	ETF	155.82	156.04	155.72	156.0	9465138.0
2013-03-11 16:00:00	SPY	ETF	156.0	156.06	155.3348	156.03	4596059.0
2013-03-11 16:30:00	SPY	ETF	156.03	156.1	155.8499	156.07	5697531.0
2013-03-11 17:00:00	SPY	ETF	156.07	156.15	156.05	156.09	1096831.0
2013-03-11 17:30:00	SPY	ETF	156.09	156.13	156.08	156.1	21036.0
2013-03-11 18:00:00	SPY	ETF	156.12	156.13	155.97	155.98	85255.0
2013-03-11 18:30:00	SPY	ETF	155.97	156.0	155.95	155.96	318510.0
2013-03-11 19:00:00	SPY	ETF	155.96	156.02	155.96	156.0	9390.0
2013-03-11 19:30:00	SPY	ETF	156.02	156.02	155.99	156.0	18518.0
2013-03-11 04:00:00	QQQ	ETF	68.51	68.56	68.51	68.56	28800.0
2013-03-11 06:30:00	QQQ	ETF	68.59	68.59	68.58	68.58	1500.0
2013-03-11 07:00:00	QQQ	ETF	68.6	68.6	68.6	68.6	400.0
2013-03-11 07:30:00	QQQ	ETF	68.53	68.57	68.53	68.57	4324.0
2013-03-11 08:00:00	QQQ	ETF	68.59	68.64	68.53	68.63	615319.0
2013-03-11 08:30:00	QQQ	ETF	68.63	68.64	68.56	68.61	776425.0
2013-03-11 09:00:00	QQQ	ETF	68.61	68.72	68.61	68.68	47922.0
2013-03-11 09:30:00	QQQ	ETF	68.68	68.71	68.57	68.61	3030806.0
2013-03-11 10:00:00	QQQ	ETF	68.62	68.665	68.53	68.531	1490758.0
2013-03-11 10:30:00	QQQ	ETF	68.54	68.59	68.47	68.53	1303386.0
2013-03-11 11:00:00	QQQ	ETF	68.52	68.64	68.5	68.6	872344.0
2013-03-11 11:30:00	QQQ	ETF	68.6	68.68	68.59	68.67	754558.0
2013-03-11 12:00:00	QQQ	ETF	68.67	68.78	68.67	68.74	1236993.0
2013-03-11 12:30:00	QQQ	ETF	68.74	68.75	68.7	68.73	745097.0
2013-03-11 13:00:00	QQQ	ETF	68.74	68.8	68.72	68.78	484226.0
2013-03-11 13:30:00	QQQ	ETF	68.775	68.835	68.745	68.76	1017374.0
2013-03-11 14:00:00	QQQ	ETF	68.76	68.77	68.72	68.7375	479855.0
2013-03-11 14:30:00	QQQ	ETF	68.733	68.978	68.69	68.914	2508129.0

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

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