PREVIEW / etf_30min / 2012-06-18

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-06-18.parquet
  size:    283 KB
  rows:    9,560

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-18 04:00:00	SPY	ETF	134.6	134.6	133.75	133.75	13296.0
2012-06-18 04:30:00	SPY	ETF	133.7	133.86	133.57	133.86	1881.0
2012-06-18 05:00:00	SPY	ETF	133.95	134.04	133.84	133.86	7540.0
2012-06-18 05:30:00	SPY	ETF	134.0	134.15	134.0	134.15	19100.0
2012-06-18 06:00:00	SPY	ETF	134.17	134.3	134.17	134.2	23650.0
2012-06-18 06:30:00	SPY	ETF	134.2	134.2	133.87	133.98	116428.0
2012-06-18 07:00:00	SPY	ETF	134.01	134.09	133.84	133.98	301018.0
2012-06-18 07:30:00	SPY	ETF	134.0	134.05	133.77	133.77	385518.0
2012-06-18 08:00:00	SPY	ETF	133.79	133.88	133.6	133.65	1177056.0
2012-06-18 08:30:00	SPY	ETF	133.65	133.8996	133.45	133.54	1162113.0
2012-06-18 09:00:00	SPY	ETF	133.56	133.73	133.52	133.57	2087251.0
2012-06-18 09:30:00	SPY	ETF	133.58	133.99	133.28	133.86	19333724.0
2012-06-18 10:00:00	SPY	ETF	133.88	134.33	133.74	134.262	12171948.0
2012-06-18 10:30:00	SPY	ETF	134.26	134.57	134.1	134.24	11884589.0
2012-06-18 11:00:00	SPY	ETF	134.24	134.26	133.85	134.09	11649701.0
2012-06-18 11:30:00	SPY	ETF	134.09	134.24	133.92	134.19	7961131.0
2012-06-18 12:00:00	SPY	ETF	134.18	134.22	134.0	134.09	4441296.0
2012-06-18 12:30:00	SPY	ETF	134.0936	134.36	134.0	134.139	5041419.0
2012-06-18 13:00:00	SPY	ETF	134.13	134.45	134.06	134.398	4518978.0
2012-06-18 13:30:00	SPY	ETF	134.398	134.54	134.35	134.5	4269371.0
2012-06-18 14:00:00	SPY	ETF	134.51	134.73	134.38	134.59	7270696.0
2012-06-18 14:30:00	SPY	ETF	134.59	134.69	134.39	134.47	5112762.0
2012-06-18 15:00:00	SPY	ETF	134.45	134.58	134.16	134.39	6012402.0
2012-06-18 15:30:00	SPY	ETF	134.39	134.51	134.18	134.42	15169177.0
2012-06-18 16:00:00	SPY	ETF	134.41	134.72	133.9078	134.63	7264828.0
2012-06-18 16:30:00	SPY	ETF	134.62	134.77	134.61	134.71	298148.0
2012-06-18 17:00:00	SPY	ETF	134.71	134.77	134.64	134.64	60890.0
2012-06-18 17:30:00	SPY	ETF	134.65	134.69	134.65	134.66	25825.0
2012-06-18 18:00:00	SPY	ETF	134.67	134.67	134.6	134.6	46068.0
2012-06-18 18:30:00	SPY	ETF	134.61	134.61	134.57	134.58	53810.0
2012-06-18 19:00:00	SPY	ETF	134.6	134.65	134.6	134.64	4848.0
2012-06-18 19:30:00	SPY	ETF	134.66	134.76	134.64	134.76	106009.0
2012-06-18 07:00:00	QQQ	ETF	62.98	63.01	62.94	63.01	27200.0
2012-06-18 07:30:00	QQQ	ETF	62.98	63.02	62.92	62.92	18856.0
2012-06-18 08:00:00	QQQ	ETF	62.9	63.47	62.82	62.85	180037.0
2012-06-18 08:30:00	QQQ	ETF	62.83	62.99	62.69	62.74	141137.0
2012-06-18 09:00:00	QQQ	ETF	62.73	62.82	62.71	62.74	162306.0
2012-06-18 09:30:00	QQQ	ETF	62.74	63.18	62.63	63.11	4935427.0
2012-06-18 10:00:00	QQQ	ETF	63.11	63.44	63.07	63.41	3991385.0
2012-06-18 10:30:00	QQQ	ETF	63.41	63.52	63.26	63.34	3339506.0
2012-06-18 11:00:00	QQQ	ETF	63.35	63.37	63.13	63.24	2749180.0
2012-06-18 11:30:00	QQQ	ETF	63.25	63.39	63.21	63.38	2375520.0
2012-06-18 12:00:00	QQQ	ETF	63.37	63.3801	63.27	63.33	932908.0
2012-06-18 12:30:00	QQQ	ETF	63.33	63.465	63.29	63.365	1168150.0
2012-06-18 13:00:00	QQQ	ETF	63.3601	63.52	63.33	63.51	1142690.0
2012-06-18 13:30:00	QQQ	ETF	63.51	63.66	63.49	63.6482	1428423.0
2012-06-18 14:00:00	QQQ	ETF	63.65	63.74	63.58	63.67	1707382.0
2012-06-18 14:30:00	QQQ	ETF	63.67	63.72	63.56	63.61	830082.0
2012-06-18 15:00:00	QQQ	ETF	63.62	63.7	63.47	63.6	1618409.0
2012-06-18 15:30:00	QQQ	ETF	63.6	63.64	63.47	63.57	4179369.0

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

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