PREVIEW / etf_30min / 2012-01-05

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-01-05.parquet
  size:    283 KB
  rows:    9,564

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-01-05 04:00:00	SPY	ETF	127.32	127.33	126.97	126.97	3050.0
2012-01-05 04:30:00	SPY	ETF	127.03	127.14	126.95	126.95	6933.0
2012-01-05 05:00:00	SPY	ETF	126.9	127.0	126.9	127.0	19600.0
2012-01-05 05:30:00	SPY	ETF	126.81	126.81	126.59	126.59	11900.0
2012-01-05 06:00:00	SPY	ETF	126.68	126.83	126.65	126.67	30990.0
2012-01-05 06:30:00	SPY	ETF	126.7	126.8	126.49	126.74	155492.0
2012-01-05 07:00:00	SPY	ETF	126.81	127.01	126.77	127.0	234764.0
2012-01-05 07:30:00	SPY	ETF	127.01	127.01	126.83	126.9	265065.0
2012-01-05 08:00:00	SPY	ETF	126.93	127.9	126.85	127.47	2562610.0
2012-01-05 08:30:00	SPY	ETF	127.5	127.62	127.14	127.22	2076403.0
2012-01-05 09:00:00	SPY	ETF	127.23	127.27	126.98	127.0	2113745.0
2012-01-05 09:30:00	SPY	ETF	127.01	127.15	126.47	126.75	23771465.0
2012-01-05 10:00:00	SPY	ETF	126.75	127.12	126.43	127.04	19720369.0
2012-01-05 10:30:00	SPY	ETF	127.05	127.08	126.67	126.87	12328338.0
2012-01-05 11:00:00	SPY	ETF	126.86	127.36	126.79	127.3398	9649811.0
2012-01-05 11:30:00	SPY	ETF	127.34	127.53	127.31	127.35	9199973.0
2012-01-05 12:00:00	SPY	ETF	127.36	127.61	127.31	127.545	8709934.0
2012-01-05 12:30:00	SPY	ETF	127.545	127.89	127.44	127.87	7958299.0
2012-01-05 13:00:00	SPY	ETF	127.87	128.03	127.75	128.02	6476406.0
2012-01-05 13:30:00	SPY	ETF	128.01	128.23	128.01	128.07	8122923.0
2012-01-05 14:00:00	SPY	ETF	128.08	128.17	127.82	127.86	8589742.0
2012-01-05 14:30:00	SPY	ETF	127.85	127.97	127.85	127.865	10130505.0
2012-01-05 15:00:00	SPY	ETF	127.865	128.05	127.78	127.93	10172762.0
2012-01-05 15:30:00	SPY	ETF	127.94	128.14	127.82	128.06	13870751.0
2012-01-05 16:00:00	SPY	ETF	128.05	128.14	127.6535	127.77	12607048.0
2012-01-05 16:30:00	SPY	ETF	127.77	127.79	127.71	127.73	457626.0
2012-01-05 17:00:00	SPY	ETF	127.73	127.73	127.59	127.64	758741.0
2012-01-05 17:30:00	SPY	ETF	127.64	127.68	127.64	127.65	29421.0
2012-01-05 18:00:00	SPY	ETF	127.67	128.1	127.62	127.68	113179.0
2012-01-05 18:30:00	SPY	ETF	127.7	127.83	127.68	127.78	271866.0
2012-01-05 19:00:00	SPY	ETF	127.74	127.85	127.73	127.74	45533.0
2012-01-05 19:30:00	SPY	ETF	127.77	127.78	127.64	127.66	78750.0
2012-01-05 04:30:00	QQQ	ETF	56.95	56.95	56.94	56.94	4500.0
2012-01-05 05:00:00	QQQ	ETF	56.91	56.92	56.9	56.9	25400.0
2012-01-05 05:30:00	QQQ	ETF	56.81	56.81	56.79	56.79	1600.0
2012-01-05 06:00:00	QQQ	ETF	56.75	56.86	56.75	56.86	12600.0
2012-01-05 06:30:00	QQQ	ETF	56.8	56.85	56.8	56.85	1600.0
2012-01-05 07:00:00	QQQ	ETF	56.85	56.93	56.85	56.93	22700.0
2012-01-05 07:30:00	QQQ	ETF	56.96	56.96	56.9	56.95	102469.0
2012-01-05 08:00:00	QQQ	ETF	56.95	57.44	56.9	57.2	392972.0
2012-01-05 08:30:00	QQQ	ETF	57.18	57.24	57.05	57.08	267613.0
2012-01-05 09:00:00	QQQ	ETF	57.08	57.11	56.97	57.01	199703.0
2012-01-05 09:30:00	QQQ	ETF	57.02	57.21	56.8	57.0	6182381.0
2012-01-05 10:00:00	QQQ	ETF	56.99	57.2	56.89	57.16	4499732.0
2012-01-05 10:30:00	QQQ	ETF	57.158	57.18	56.97	57.05	2121328.0
2012-01-05 11:00:00	QQQ	ETF	57.06	57.22	57.0	57.21	2245870.0
2012-01-05 11:30:00	QQQ	ETF	57.21	57.32	57.21	57.2434	1899910.0
2012-01-05 12:00:00	QQQ	ETF	57.249	57.37	57.22	57.34	3403693.0
2012-01-05 12:30:00	QQQ	ETF	57.35	57.439	57.27	57.43	1476416.0
2012-01-05 13:00:00	QQQ	ETF	57.42	57.525	57.38	57.52	2029194.0

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

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