PREVIEW / etf_30min / 2012-03-12

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-03-12.parquet
  size:    275 KB
  rows:    9,384

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-03-12 04:00:00	SPY	ETF	137.22	137.22	137.21	137.21	880.0
2012-03-12 04:30:00	SPY	ETF	137.2	137.38	137.2	137.38	22700.0
2012-03-12 05:00:00	SPY	ETF	137.57	137.68	137.57	137.66	10700.0
2012-03-12 05:30:00	SPY	ETF	137.67	137.68	137.67	137.68	7700.0
2012-03-12 06:30:00	SPY	ETF	137.63	137.65	137.57	137.57	22700.0
2012-03-12 07:00:00	SPY	ETF	137.55	137.64	137.5	137.63	73689.0
2012-03-12 07:30:00	SPY	ETF	137.59	137.6	137.47	137.53	179040.0
2012-03-12 08:00:00	SPY	ETF	137.53	137.65	137.3	137.33	367418.0
2012-03-12 08:30:00	SPY	ETF	137.32	137.48	137.25	137.48	535613.0
2012-03-12 09:00:00	SPY	ETF	137.47	137.67	137.46	137.55	842591.0
2012-03-12 09:30:00	SPY	ETF	137.55	137.76	137.39	137.52	12954475.0
2012-03-12 10:00:00	SPY	ETF	137.51	137.54	137.27	137.38	13693106.0
2012-03-12 10:30:00	SPY	ETF	137.37	137.45	137.17	137.35	8022223.0
2012-03-12 11:00:00	SPY	ETF	137.35	137.42	137.17	137.28	7516001.0
2012-03-12 11:30:00	SPY	ETF	137.27	137.39	137.18	137.2	7041077.0
2012-03-12 12:00:00	SPY	ETF	137.19	137.46	137.09	137.355	7086825.0
2012-03-12 12:30:00	SPY	ETF	137.36	137.42	137.27	137.38	4239261.0
2012-03-12 13:00:00	SPY	ETF	137.37	137.455	137.29	137.43	2376324.0
2012-03-12 13:30:00	SPY	ETF	137.4203	137.67	137.41	137.535	5608343.0
2012-03-12 14:00:00	SPY	ETF	137.535	137.64	137.48	137.58	3590853.0
2012-03-12 14:30:00	SPY	ETF	137.58	137.63	137.5	137.63	3354131.0
2012-03-12 15:00:00	SPY	ETF	137.63	137.69	137.53	137.615	3666327.0
2012-03-12 15:30:00	SPY	ETF	137.615	137.64	137.4515	137.57	13301846.0
2012-03-12 16:00:00	SPY	ETF	137.57	137.76	137.25	137.73	6626687.0
2012-03-12 16:30:00	SPY	ETF	137.74	137.74	137.5488	137.72	661198.0
2012-03-12 17:00:00	SPY	ETF	137.73	137.82	137.72	137.81	110050.0
2012-03-12 17:30:00	SPY	ETF	137.8	137.81	137.76	137.78	42330.0
2012-03-12 18:00:00	SPY	ETF	137.76	137.79	137.72	137.72	17665.0
2012-03-12 18:30:00	SPY	ETF	137.71	137.79	137.71	137.78	27500.0
2012-03-12 19:00:00	SPY	ETF	137.77	137.78	137.76	137.77	4955.0
2012-03-12 19:30:00	SPY	ETF	137.76	137.83	137.76	137.79	80271.0
2012-03-12 07:00:00	QQQ	ETF	64.95	64.98	64.95	64.96	9100.0
2012-03-12 07:30:00	QQQ	ETF	64.97	64.99	64.91	64.93	22700.0
2012-03-12 08:00:00	QQQ	ETF	64.95	64.96	64.86	64.87	145895.0
2012-03-12 08:30:00	QQQ	ETF	64.87	64.94	64.84	64.94	267125.0
2012-03-12 09:00:00	QQQ	ETF	64.94	65.01	64.94	64.97	198790.0
2012-03-12 09:30:00	QQQ	ETF	64.97	65.11	64.929	65.05	3945376.0
2012-03-12 10:00:00	QQQ	ETF	65.05	65.06	64.88	64.92	3647512.0
2012-03-12 10:30:00	QQQ	ETF	64.92	64.92	64.78	64.86	3443633.0
2012-03-12 11:00:00	QQQ	ETF	64.86	64.9	64.72	64.79	2580228.0
2012-03-12 11:30:00	QQQ	ETF	64.79	64.89	64.78	64.82	2411051.0
2012-03-12 12:00:00	QQQ	ETF	64.82	64.98	64.78	64.91	1422644.0
2012-03-12 12:30:00	QQQ	ETF	64.91	64.97	64.86	64.95	1167925.0
2012-03-12 13:00:00	QQQ	ETF	64.95	64.97	64.89	64.95	708316.0
2012-03-12 13:30:00	QQQ	ETF	64.95	65.08	64.95	65.0062	1879048.0
2012-03-12 14:00:00	QQQ	ETF	65.0	65.06	64.99	65.005	970842.0
2012-03-12 14:30:00	QQQ	ETF	65.009	65.02	64.96	65.02	712362.0
2012-03-12 15:00:00	QQQ	ETF	65.019	65.04	64.95	65.0	1745832.0
2012-03-12 15:30:00	QQQ	ETF	65.0	65.03	64.93	65.03	2583688.0
2012-03-12 16:00:00	QQQ	ETF	65.03	65.14	65.02	65.12	540439.0

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

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