PREVIEW / etf_30min / 2009-08-04

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-08-04.parquet
  size:    232 KB
  rows:    7,735

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
2009-08-04 04:00:00	SPY	ETF	99.98	99.98	99.93	99.93	1700.0
2009-08-04 04:30:00	SPY	ETF	99.86	99.86	99.74	99.76	2139.0
2009-08-04 05:00:00	SPY	ETF	99.73	99.91	99.68	99.91	3760.0
2009-08-04 05:30:00	SPY	ETF	99.84	99.91	99.84	99.91	12100.0
2009-08-04 06:00:00	SPY	ETF	99.82	99.83	99.74	99.83	13456.0
2009-08-04 06:30:00	SPY	ETF	99.83	99.88	99.75	99.76	49338.0
2009-08-04 07:00:00	SPY	ETF	99.74	99.88	99.71	99.71	246091.0
2009-08-04 07:30:00	SPY	ETF	99.71	99.84	99.71	99.75	363985.0
2009-08-04 08:00:00	SPY	ETF	99.77	99.92	99.71	99.83	565310.0
2009-08-04 08:30:00	SPY	ETF	99.81	100.03	99.69	99.8	928196.0
2009-08-04 09:00:00	SPY	ETF	99.81	100.03	99.81	100.0	968182.0
2009-08-04 09:30:00	SPY	ETF	99.99	100.18	99.78	100.18	18979895.0
2009-08-04 10:00:00	SPY	ETF	100.15	100.36	99.9	100.01	18198317.0
2009-08-04 10:30:00	SPY	ETF	100.01	100.29	99.9	100.25	8398995.0
2009-08-04 11:00:00	SPY	ETF	100.245	100.5	100.24	100.39	8416881.0
2009-08-04 11:30:00	SPY	ETF	100.38	100.62	100.33	100.53	9248064.0
2009-08-04 12:00:00	SPY	ETF	100.5291	100.77	100.43	100.69	8940682.0
2009-08-04 12:30:00	SPY	ETF	100.68	100.84	100.25	100.8196	6221422.0
2009-08-04 13:00:00	SPY	ETF	100.81	100.84	100.57	100.66	7465388.0
2009-08-04 13:30:00	SPY	ETF	100.66	100.68	100.21	100.26	12072900.0
2009-08-04 14:00:00	SPY	ETF	100.25	100.41	100.16	100.38	12146506.0
2009-08-04 14:30:00	SPY	ETF	100.39	100.6	100.21	100.27	10762785.0
2009-08-04 15:00:00	SPY	ETF	100.2606	100.51	100.19	100.26	7917526.0
2009-08-04 15:30:00	SPY	ETF	100.26	100.69	100.15	100.69	25187831.0
2009-08-04 16:00:00	SPY	ETF	100.69	100.93	99.921	100.87	17651502.0
2009-08-04 16:30:00	SPY	ETF	100.87	100.95	100.4002	100.92	1423541.0
2009-08-04 17:00:00	SPY	ETF	100.92	100.98	100.88	100.97	192224.0
2009-08-04 17:30:00	SPY	ETF	100.94	100.96	100.92	100.95	23022.0
2009-08-04 18:00:00	SPY	ETF	100.98	100.98	100.92	100.95	39331.0
2009-08-04 18:30:00	SPY	ETF	100.94	100.95	100.1601	100.94	30710.0
2009-08-04 19:00:00	SPY	ETF	100.93	100.95	100.91	100.94	27794.0
2009-08-04 19:30:00	SPY	ETF	100.92	100.94	100.9	100.92	36285.0
2009-08-04 04:00:00	QQQ	ETF	39.85	39.85	39.79	39.8	10573.0
2009-08-04 04:30:00	QQQ	ETF	39.81	39.81	39.78	39.78	2374.0
2009-08-04 05:00:00	QQQ	ETF	39.78	39.78	39.78	39.78	5000.0
2009-08-04 05:30:00	QQQ	ETF	39.79	39.79	39.79	39.79	100.0
2009-08-04 06:00:00	QQQ	ETF	39.79	39.79	39.75	39.75	500.0
2009-08-04 06:30:00	QQQ	ETF	39.79	39.79	39.72	39.72	14403.0
2009-08-04 07:00:00	QQQ	ETF	39.74	39.79	39.73	39.73	62024.0
2009-08-04 07:30:00	QQQ	ETF	39.76	39.79	39.75	39.76	90568.0
2009-08-04 08:00:00	QQQ	ETF	39.77	39.8	39.74	39.78	174404.0
2009-08-04 08:30:00	QQQ	ETF	39.77	39.91	39.74	39.77	229662.0
2009-08-04 09:00:00	QQQ	ETF	39.79	39.86	39.79	39.86	802833.0
2009-08-04 09:30:00	QQQ	ETF	39.86	39.94	39.77	39.89	10606840.0
2009-08-04 10:00:00	QQQ	ETF	39.89	40.01	39.83	39.89	11555903.0
2009-08-04 10:30:00	QQQ	ETF	39.89	39.9505	39.85	39.93	6309629.0
2009-08-04 11:00:00	QQQ	ETF	39.93	40.0	39.91	39.95	2683312.0
2009-08-04 11:30:00	QQQ	ETF	39.96	40.09	39.9315	40.05	5827902.0
2009-08-04 12:00:00	QQQ	ETF	40.06	40.09	40.01	40.0486	3863153.0
2009-08-04 12:30:00	QQQ	ETF	40.0401	40.14	40.02	40.14	2660113.0

> showing 50 of 7,735 rows — these rows as CSV

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