PREVIEW / etf_30min / 2010-11-12

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-11-12.parquet
  size:    275 KB
  rows:    9,146

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
2010-11-12 04:00:00	SPY	ETF	120.75	120.75	120.19	120.4	111634.0
2010-11-12 04:30:00	SPY	ETF	120.4	120.48	120.3	120.48	8800.0
2010-11-12 05:00:00	SPY	ETF	120.5	120.65	120.5	120.65	6618.0
2010-11-12 05:30:00	SPY	ETF	120.78	121.11	120.7	121.0	49375.0
2010-11-12 06:00:00	SPY	ETF	120.95	120.95	120.66	120.69	31050.0
2010-11-12 06:30:00	SPY	ETF	120.79	120.89	120.72	120.89	143950.0
2010-11-12 07:00:00	SPY	ETF	120.85	121.01	120.8	120.9	305122.0
2010-11-12 07:30:00	SPY	ETF	120.91	120.93	120.71	120.77	446139.0
2010-11-12 08:00:00	SPY	ETF	120.76	120.89	120.01	120.85	1303789.0
2010-11-12 08:30:00	SPY	ETF	120.85	121.05	120.71	121.01	876798.0
2010-11-12 09:00:00	SPY	ETF	121.01	121.07	120.81	120.81	1233969.0
2010-11-12 09:30:00	SPY	ETF	120.82	121.35	120.71	121.22	25782149.0
2010-11-12 10:00:00	SPY	ETF	121.21	121.32	120.75	120.79	19802237.0
2010-11-12 10:30:00	SPY	ETF	120.79	120.82	120.31	120.37	22225135.0
2010-11-12 11:00:00	SPY	ETF	120.38	120.8663	120.21	120.63	14070575.0
2010-11-12 11:30:00	SPY	ETF	120.6	120.64	120.18	120.3225	11801131.0
2010-11-12 12:00:00	SPY	ETF	120.3299	120.41	119.86	119.87	15473194.0
2010-11-12 12:30:00	SPY	ETF	119.87	120.03	119.68	119.7899	18105416.0
2010-11-12 13:00:00	SPY	ETF	119.79	119.99	119.65	119.9478	13456192.0
2010-11-12 13:30:00	SPY	ETF	119.95	120.1	119.76	119.79	9073656.0
2010-11-12 14:00:00	SPY	ETF	119.79	120.09	119.71	119.88	9510659.0
2010-11-12 14:30:00	SPY	ETF	119.88	120.26	119.78	120.105	14053488.0
2010-11-12 15:00:00	SPY	ETF	120.1	120.41	120.01	120.12	17029678.0
2010-11-12 15:30:00	SPY	ETF	120.12	120.27	119.95	120.2	31956234.0
2010-11-12 16:00:00	SPY	ETF	120.19	120.935	119.885	120.04	9040512.0
2010-11-12 16:30:00	SPY	ETF	120.03	120.09	119.98	120.04	319094.0
2010-11-12 17:00:00	SPY	ETF	120.04	120.04	119.91	119.97	222612.0
2010-11-12 17:30:00	SPY	ETF	120.0	120.0	119.9	119.91	35336.0
2010-11-12 18:00:00	SPY	ETF	119.92	120.18	119.9	119.93	94125.0
2010-11-12 18:30:00	SPY	ETF	119.91	119.98	119.91	119.96	14901.0
2010-11-12 19:00:00	SPY	ETF	119.93	119.97	119.92	119.93	8525.0
2010-11-12 19:30:00	SPY	ETF	119.93	119.95	119.85	119.85	20710.0
2010-11-12 04:00:00	QQQ	ETF	52.8	52.89	52.77	52.89	695.0
2010-11-12 04:30:00	QQQ	ETF	52.86	52.86	52.84	52.85	300.0
2010-11-12 05:00:00	QQQ	ETF	52.94	52.95	52.87	52.87	3400.0
2010-11-12 05:30:00	QQQ	ETF	53.02	53.02	53.02	53.02	299.0
2010-11-12 06:00:00	QQQ	ETF	52.95	53.05	52.91	53.03	12300.0
2010-11-12 06:30:00	QQQ	ETF	53.06	53.06	53.0	53.06	250200.0
2010-11-12 07:00:00	QQQ	ETF	53.08	53.15	53.04	53.13	76143.0
2010-11-12 07:30:00	QQQ	ETF	53.1	53.12	53.02	53.04	52368.0
2010-11-12 08:00:00	QQQ	ETF	53.06	53.06	52.98	53.04	623424.0
2010-11-12 08:30:00	QQQ	ETF	53.05	53.13	53.0	53.11	533874.0
2010-11-12 09:00:00	QQQ	ETF	53.11	53.19	53.07	53.11	767941.0
2010-11-12 09:30:00	QQQ	ETF	53.11	53.32	53.06	53.26	11266634.0
2010-11-12 10:00:00	QQQ	ETF	53.27	53.285	53.04	53.06	6358556.0
2010-11-12 10:30:00	QQQ	ETF	53.05	53.07	52.73	52.75	9861976.0
2010-11-12 11:00:00	QQQ	ETF	52.75	52.87	52.68	52.85	4704887.0
2010-11-12 11:30:00	QQQ	ETF	52.8425	52.86	52.64	52.7	4420763.0
2010-11-12 12:00:00	QQQ	ETF	52.69	52.72	52.25	52.25	7023879.0
2010-11-12 12:30:00	QQQ	ETF	52.25	52.36	52.11	52.265	8922477.0

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

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