PREVIEW / etf_30min / 2010-04-09

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-04-09.parquet
  size:    245 KB
  rows:    8,228

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-04-09 04:00:00	SPY	ETF	119.14	119.15	119.11	119.15	1300.0
2010-04-09 05:30:00	SPY	ETF	119.1	119.12	119.0	119.08	1400.0
2010-04-09 06:00:00	SPY	ETF	119.04	119.07	119.04	119.05	450.0
2010-04-09 06:30:00	SPY	ETF	119.1	119.15	119.1	119.15	18500.0
2010-04-09 07:00:00	SPY	ETF	119.13	119.18	119.1	119.13	114210.0
2010-04-09 07:30:00	SPY	ETF	119.11	119.15	119.09	119.09	351575.0
2010-04-09 08:00:00	SPY	ETF	119.09	119.15	119.09	119.14	223446.0
2010-04-09 08:30:00	SPY	ETF	119.14	119.15	119.07	119.07	411900.0
2010-04-09 09:00:00	SPY	ETF	119.06	119.07	118.97	119.02	1332059.0
2010-04-09 09:30:00	SPY	ETF	119.02	119.16	118.81	119.1383	24376634.0
2010-04-09 10:00:00	SPY	ETF	119.13	119.3	118.8	118.93	14611901.0
2010-04-09 10:30:00	SPY	ETF	118.935	119.18	118.85	118.99	14912477.0
2010-04-09 11:00:00	SPY	ETF	118.99	119.28	118.97	119.27	7733095.0
2010-04-09 11:30:00	SPY	ETF	119.27	119.36	119.19	119.26	7957087.0
2010-04-09 12:00:00	SPY	ETF	119.2583	119.34	119.22	119.3	3304148.0
2010-04-09 12:30:00	SPY	ETF	119.31	119.31	119.14	119.18	3551268.0
2010-04-09 13:00:00	SPY	ETF	119.18	119.21	119.0	119.2	6119937.0
2010-04-09 13:30:00	SPY	ETF	119.2	119.25	119.04	119.055	4763181.0
2010-04-09 14:00:00	SPY	ETF	119.05	119.26	118.97	119.2	6207086.0
2010-04-09 14:30:00	SPY	ETF	119.19	119.28	119.14	119.22	3945823.0
2010-04-09 15:00:00	SPY	ETF	119.22	119.35	119.13	119.33	5432483.0
2010-04-09 15:30:00	SPY	ETF	119.335	119.6	119.28	119.54	15074379.0
2010-04-09 16:00:00	SPY	ETF	119.54	119.77	118.7514	119.69	8910664.0
2010-04-09 16:30:00	SPY	ETF	119.69	119.72	119.66	119.68	617190.0
2010-04-09 17:00:00	SPY	ETF	119.68	119.7	119.63	119.66	135615.0
2010-04-09 17:30:00	SPY	ETF	119.66	119.74	119.66	119.74	76028.0
2010-04-09 18:00:00	SPY	ETF	119.74	119.76	119.72	119.73	39041.0
2010-04-09 18:30:00	SPY	ETF	119.74	119.82	119.74	119.82	50946.0
2010-04-09 19:00:00	SPY	ETF	119.84	119.88	119.8	119.81	37281.0
2010-04-09 19:30:00	SPY	ETF	119.78	119.92	119.75	119.87	177520.0
2010-04-09 06:30:00	QQQ	ETF	48.85	48.85	48.85	48.85	500.0
2010-04-09 07:00:00	QQQ	ETF	48.85	48.88	48.85	48.88	4700.0
2010-04-09 07:30:00	QQQ	ETF	48.87	48.88	48.84	48.86	71600.0
2010-04-09 08:00:00	QQQ	ETF	48.84	48.85	48.83	48.85	24550.0
2010-04-09 08:30:00	QQQ	ETF	48.84	48.85	48.83	48.83	31125.0
2010-04-09 09:00:00	QQQ	ETF	48.83	48.83	48.76	48.77	151612.0
2010-04-09 09:30:00	QQQ	ETF	48.77	48.82	48.635	48.7799	8263443.0
2010-04-09 10:00:00	QQQ	ETF	48.78	48.83	48.68	48.7238	6145974.0
2010-04-09 10:30:00	QQQ	ETF	48.72	48.85	48.69	48.775	6925015.0
2010-04-09 11:00:00	QQQ	ETF	48.77	48.87	48.77	48.86	2945819.0
2010-04-09 11:30:00	QQQ	ETF	48.8699	48.9	48.83	48.86	3221016.0
2010-04-09 12:00:00	QQQ	ETF	48.86	48.9	48.8057	48.883	1528251.0
2010-04-09 12:30:00	QQQ	ETF	48.89	48.89	48.84	48.8638	1677769.0
2010-04-09 13:00:00	QQQ	ETF	48.86	48.89	48.8	48.88	2576662.0
2010-04-09 13:30:00	QQQ	ETF	48.88	48.91	48.82	48.83	1886762.0
2010-04-09 14:00:00	QQQ	ETF	48.83	48.92	48.79	48.8899	2416873.0
2010-04-09 14:30:00	QQQ	ETF	48.89	48.93	48.86	48.91	2283540.0
2010-04-09 15:00:00	QQQ	ETF	48.91	48.99	48.87	48.99	2835436.0
2010-04-09 15:30:00	QQQ	ETF	48.98	49.05	48.94	49.02	6313799.0
2010-04-09 16:00:00	QQQ	ETF	49.02	49.06	48.7938	49.06	3356165.0

> showing 50 of 8,228 rows — these rows as CSV

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